SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

can I use if statement in SQL???

60331May 16 2002

Hello everyone.
I know that this is a silly question. The answer is no. Instead I should use decode function.
But what if I dont know all possible outcomes, can I still use decode function?
Also, I have created a view, in the where clause i want to use if statement. Is it possible to do?
Thanks in advance,
Sonya

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 13 2002

Added on May 16 2002

12 comments

562 views