Re: examining views
Date: Fri, 5 Mar 2004 08:22:21 -0500
Message-ID: <HYWdnejQ-bfVHdXdRVn-ug_at_comcast.com>
"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 - 14:22:21 CET