Databases
cancel
Showing results for
Did you mean:

SOLVED
Go to solution

## 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
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)
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
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.