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?
[Edited by Donna on 04-10-2001 at 10:31 AM]
Did you specify all of the columns before your query where you tell oracle the name,size, and format of your columns?
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.
Can you post your queries (both sql/plsql) so that we can have a look ? I don't think there should be any difference.
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
Click Here to Expand Forum to Full Width