-
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,
-
Hey mdorn66
Double click on LONG column value.
-
set lines 80
set long 1000000
select view_name,text from dba_views@doppler where owner='CRA_SNAP'
;
are u looking for this .
-
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