dbTalk Databases Forums  

examining the select statement for a view

comp.database.oracle comp.database.oracle


Discuss examining the select statement for a view in the comp.database.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
UNIXNewBie
 
Posts: n/a

Default examining the select statement for a view - 03-04-2004 , 03:56 PM






I 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.




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.