No you cannot, but you can include decode into decode so creating some kind of logic. Better look at CASE statement, less cryptic, more readable and understandable.
Gints Plivna http://www.gplivna.eu On 26 Sept., 13:18, "Roopesh S" <[EMAIL PROTECTED]> wrote: > HI there, > > I have a table "TSL_BASE_PRODUCT_V"; My Condition is as follows: > > If NON_RETAIL_IND = 'Y', display as 'O' > If NON_RETAIL_IND = 'N' and DELIVERY_AUTHORISATION_TYPE = 'N' display > as 'R' > If NON_RETAIL_IND = 'N' and DELIVERY_AUTHORISATION_TYPE NOT= 'N', > display as 'B' > > 1 more question.. Can i use "AND" operator in decode???? > -- > Thanx'N'Regards > Roopesh --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
