Very URGEnt help on decode
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Very URGEnt help on decode

  1. #1
    Join Date
    Jul 2000
    Location
    brewster,Newyork
    Posts
    87

    Very URGEnt help on decode

    I need a code pls help me out here
    I have a select statement with create view tntvie as
    select (seq,1,x1,2,x2,3,x3....to 248)Obviously decode cant take more than 255 variables, so please help me nodify to do this.
    Im new in writing scripts urgent
    sat

  2. #2
    Join Date
    Jan 2004
    Posts
    58

    Smile re: options

    TRY ...


    CASE statements

    or a PL/SQL procedure
    thanks,
    harish

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    IMHO, you'd be better having a lookup table that specified the values and their corresponding meaning.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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