DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: DECODE AND REPORTS

  1. #1
    Join Date
    Mar 2001
    Posts
    52

    Talking

    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]

  2. #2
    Join Date
    Jan 2001
    Posts
    515

    Specify

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

  3. #3
    Join Date
    Mar 2001
    Posts
    52
    YES.

  4. #4
    Join Date
    Aug 2000
    Posts
    462
    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.

  5. #5
    Join Date
    Oct 2000
    Posts
    467
    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

  6. #6
    Join Date
    Mar 2001
    Posts
    52

    Cool

    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
  •  


Click Here to Expand Forum to Full Width