Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

How to get the full text in the text field of dba_views ??

SOLVED
Go to solution
Chris Fung
Frequent Advisor

How to get the full text in the text field of dba_views ??

Hello there,

I just want to know how can I get obtain the full text in the text field of dba_views. What I need to do is getting information on what the user views are doing what ?

Cheers,

Chris,
3 REPLIES
Yogeeraj_1
Honored Contributor

Re: How to get the full text in the text field of dba_views ??

hi Chris,

To obtain the text field of dba_views, try:
select text
from dba_views
where view_name = upper('&ViewName');

you may also specify the "owner" of the view in the query...

please clarify the second part of the question.

thanks
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Brian Crabtree
Honored Contributor
Solution

Re: How to get the full text in the text field of dba_views ??

set long 2000
select text from dba_views where view_name = '';

Thanks,

Brian
Thierry Poels_1
Honored Contributor

Re: How to get the full text in the text field of dba_views ??

yep, "set long nnnn"
or use a GUI (Enterprise Manager, TOAD, ....)

regards,
Thierry.
All unix flavours are exactly the same . . . . . . . . . . for end users anyway.