DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: decode in plsql

  1. #1
    Join Date
    Dec 2002
    Posts
    110

    decode in plsql

    hi

    how to emulate decode functionality in plsql. I have an plsqltable
    which i am iterating through while iterating i want to change the
    values of some array elements returned something like decode

    How to get this as decode doent work in plsql


    Rgrds

  2. #2
    Join Date
    Feb 2003
    Location
    Pak
    Posts
    64
    Decode function can only be used in SELECT statement.

    Basically decode function gives the functionality of IF ELSIF and ELSE in so short code, but in plsql you have to use the IF ELSIF and ELSE to get your output.

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