Conditional where clause

[swhitt]

I have created a view to return values that are similar and I need to add an if then else condition in the where clause of the view. Is it possible to add a pl/sql procedure to a view? If not, what's the best way to do this?

 

[sem]

Yes, you may use user-defined function (untill some limit, of course), but you may also use either DECODE or CASE sql constructs.

Regards, Dima

http://seminihin.narod.ru

 

[swhitt]

Thanks for your response. Could you elaborate just a bit more please?

 

[sem]

No, this is too simple, just look at select syntax in Oracle manuals.

Regards, Dima

http://seminihin.narod.ru

 

[SantaMufasa]

SWhitt,

Dima and I usually agree on things, but I'll take a chance here that we can provide a solution to meet your needs if you are willing to post "SQL pseudo-code" of what you are trying to do (that is, post code that would do what you want to do if it was syntactically legal.

Mufasa
(aka Dave of Sandy, Utah, USA @ 18:42 (25Feb04) UTC (aka "GMT" and "Zulu&quot, 11:42 (25Feb04) Mountain Time)