-
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
-
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.
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|