DECODE AND REPORTS

[Donna]

I have a query with nested DECODE.
I run the query in SQL.Perfect results.
Create a Report with the same query AND I do not get all the values.
Is this because nested DECODE behave different in SQL vs. PL/SQL?
Any suggestions?

Thanks'

[Edited by Donna on 04-10-2001 at 10:31 AM]

[lesstjm]

Did you specify all of the columns before your query where you tell oracle the name,size, and format of your columns?

[Donna]

YES.

[kmesser]

I have experienced this also, particularly with very large queries - those queries whose select text is long, not neccesarily a large result set.

We got around it using views.

[vinit]

Can you post your queries (both sql/plsql) so that we can have a look ? I don't think there should be any difference.

Cheers

[Donna]

DONE!
I believe that because of nested DECODE Developer 2000/Reports behaves different than SQL*PLUS.
So, I used to_char,to_number in the DECODE.

But the question still remains why even in Output Report some times the value was displayed and other times not for the same conditions

Thanks'
Donna