1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Can't alias a nested CASE function

Discussion in 'SQL PL/SQL' started by jeffwode, Sep 16, 2013.

  1. jeffwode

    jeffwode Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Hi,

    Just wondering why i get an ora-00905 missing keyword error when i try running this:

    "nested case" seems to be the problem. if i remove this alias the query runs fine, but i don't know why. the alias "test case" works fine :confused:

    any ideas guys?

    cheers,

    jeff
     
  2. jeffwode

    jeffwode Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    problem solved :)
     
  3. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,345
    Likes Received:
    347
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    And how did you solve this? Others might need to know how you did it.