Re: examining views

"UNIXNewBie" <nospan_at_nospam.com> wrote in message news:dpCdncJpPuzV59XdRVn-ug_at_magma.ca...
| want to determine the select statement for a view.
|
| I have found a view called ALL_VIEWS which looks promising for this
 purpose.
| The view contains a column called TEXT which appears to have the
 information
| I am looking for. However, when I perform the following select I cannot
 see
| all of the field TEXT. It's truncated for some reason. I have used SET
| LINESIZE to 32000 to no avail!
|
| two questions
|
| 1) why is this field truncated?
|
| 2) how do I determine the select statement for a view without using the
| management GUIs?
|
| Thanks
|
| J.
|
|

presumably you're using sql*plus

the TEXT column is datatype LONG

by default sql*plus only displays the first 80 characters of a LONGS

issue 'SET LONG nn' to see more (ie, nn) characters

;-{ mcs Received on Fri Mar 05 2004 - 07:22:21 CST