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

[Chris Fung]

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,

[Yogeeraj_1]

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

[Brian Crabtree · Accepted solution]

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

Thanks,

Brian

[Thierry Poels_1]

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

regards,
Thierry.