True not a valid identifier

[enuss]

I am getting ORA-00904 Error when running the below expression :

DECODE(CEXRPTSUMMARYDETAIL,0,False,True) AS ExceptionSummary

Does anyone know what the correct identifier is for a boolean expression like this?

Erich

 

[KenCunningham]

Maybe N,Y?

I don't mind people who aren't what they seem. I just wish they'd make their mind up.

 

[Dagon]

There is no simple answer. It depends on what is in the column CEXRPTSUMMARYDETAIL. It could be 'Y' or 'N'/0 or 1/'T' or 'F', or something else entirely. Try doing "select distinct CEXRPTSUMMARYDETAIL from table" and see what you get back.

 

[SantaMufasa]

Erich,

As you know, TRUE and FALSE, in and of themselves, are BOOLEAN expressions. Oracle's DECODE function is not prepared to use either TRUE or FALSE as any of its arguments or resulting-expression value. Therefore, the best that you can hope for is to produce CHARACTER expressions (via single quotes) that represent TRUE or FALSE values. You can say:

DECODE(CEXRPTSUMMARYDETAIL,0,'False','True') AS ExceptionSummary

...or...

DECODE(CEXRPTSUMMARYDETAIL,0,'F','T') AS ExceptionSummary

...or...

DECODE(CEXRPTSUMMARYDETAIL
        ,0,'<any other value that represents FALSE>'
        ,'<any other value that represents TRUE>')
        AS ExceptionSummary

Let us know if this is useful to you.


Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]