examining views

[UNIXNewBie]

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.

[Mark C. Stock]

Re: examining views


"UNIXNewBie " <nospan@nospam. comwrote in message
news:dpCdncJpPu zV59XdRVn-ug@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