DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: case in pl/sql block.....

  1. #11
    Join Date
    Jun 2003
    Location
    India
    Posts
    24
    thanks tom,

    may i know why we can't use CASE in 8.1.0.6?

    kanna.

  2. #12
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    Originally posted by kanna
    may i know why we can't use CASE in 8.1.0.6?
    You can use it in sql.
    Not in pl/sql becuse Oracle did not implement it in pl/sql engine.
    You can use decode or dynamic sql from within pl/sql block as a workaround.
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width