Home » SQL & PL/SQL » SQL & PL/SQL » decode doubt (oracle, 9.2.0.8. unix)
decode doubt [message #285349] Tue, 04 December 2007 05:09 Go to next message
vickey_sagar1
Messages: 77
Registered: August 2007
Location: pune
Member


Hi,

There is any way to run sql query inside the decode block in pl/sql script.

Some thing like this

 select decode (select 1 from dual,select 1 from dual,'Y','N') from dual


Thanks in advance,

Sagar
Re: decode doubt [message #285352 is a reply to message #285349] Tue, 04 December 2007 05:12 Go to previous messageGo to next message
kir_ait
Messages: 198
Registered: November 2007
Location: Bangalore,India
Senior Member

Yes, In your query use proper brackets. It will work

Regards,
Kiran.
Re: decode doubt [message #285355 is a reply to message #285352] Tue, 04 December 2007 05:16 Go to previous message
vickey_sagar1
Messages: 77
Registered: August 2007
Location: pune
Member

Thx Kiran!! it is working now
Previous Topic: insert table?
Next Topic: how can i get missing dates
Goto Forum:
  


Current Time: Sat Dec 10 05:16:28 CST 2016

Total time taken to generate the page: 0.11667 seconds