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

Thread: Help: SQL NAVIGATOR

  1. #1
    Join Date
    Oct 2002
    Location
    Tallahassee,Fl
    Posts
    8

    Help: SQL NAVIGATOR

    Hello all, I wanted know is there anyone out there that is familiar with sql navigator? I am trying to display the text from a view, but I keep getting a '(LONG)' in the text column. For example:

    select view_name,text from dba_views@doppler where owner='CRA_SNAP'
    1 row(s) selected
    VIEW_NAME TEXT
    ------------------------------ ----------
    ADJUSTMENTS (LONG)
    ADJUST_RSN_CODES (LONG)
    CASHLISTINGS (LONG)
    CASHLIST_AREAS (LONG)
    CL_SAMAS_CODES (LONG)

    Can anyone tell me what I could do to display the text?
    Thanks,
    M.D

  2. #2
    Join Date
    Oct 2001
    Location
    GA, USA
    Posts
    79
    Hey mdorn66

    Double click on LONG column value.
    Circumstances do not rise to meet our expectation. Embrace what you actually get. Open your eyes. See things for what they really are Thereby sparing yourself the pain of false attachements.

  3. #3
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    set lines 80
    set long 1000000
    select view_name,text from dba_views@doppler where owner='CRA_SNAP'
    ;
    are u looking for this .
    siva prakash
    DBA

  4. #4
    Join Date
    Oct 2002
    Location
    Tallahassee,Fl
    Posts
    8

    Help: SQL NAVIGATOR

    THANKS,
    But but if I double click on the text column I get what I want in a pop up window and I want it to display under the column heading. I tried setting the width but I guess that only works in sql plus and I want to export it into an excel spreadsheet. By the way I am using sql navigator 4, if that makes a difference.

    thanks again
    M.D

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