Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Problem qith querying View source
Dear Oracle Experts,
I try to get the Select statement which forms a special view. If I do that with e.g.
" select text from dba_views where view_name='DBA_REGISTRY' "
I get only the first part of that select statement (assumingly until the first carriage return).
Is there a possibility to query the whole text of a view ?
Best regards,
Daniel Wetzler Received on Thu Mar 09 2006 - 08:27:21 CST
![]() |
![]() |