-
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]
-
Specify
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.
Cheers
-
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