Skip to Main Content
Forums

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!

Function to return yes or no

647768Jul 9 2008 — edited Jul 9 2008
Good people please help;
I would like to write a function that checks a userid and returns "Yes" if the user is an inspector and returns "No" if the user is not an inspector. I want to use DECODE but have no idea how to go about it since I am new to oracle and writing functions in general.
Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 6 2008
Added on Jul 9 2008
9 comments
1,288 views