-
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
Vinit
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|