By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,196 Members | 973 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,196 IT Pros & Developers. It's quick & easy.

examining views

P: n/a
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.
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

"UNIXNewBie" <no****@nospam.com> wrote in message
news:dp********************@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
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.