examining views
From: UNIXNewBie <nospan_at_nospam.com>
Date: Fri, 5 Mar 2004 08:02:04 -0500
Message-ID: <dpCdncJpPuzV59XdRVn-ug_at_magma.ca>
Date: Fri, 5 Mar 2004 08:02:04 -0500
Message-ID: <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
Thanks
J.