why we cannot use decode in pl sql blocks ?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mohmedsobhy
    New Member
    • May 2011
    • 1

    #1

    why we cannot use decode in pl sql blocks ?

    Why we cannot use decode in pl sql blocks ?
    Last edited by Niheel; May 17 '11, 06:42 AM. Reason: Please use bold only in appropriate times.
  • rski
    Recognized Expert Contributor
    • Dec 2006
    • 700

    #2
    Actually you can, but you should put it into
    Code:
    SELECT decode(...) INTO variable FROM dual;
    block.

    Comment

    Working...