Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Problem qith querying View source

Problem qith querying View source

From: Daniel Wetzler <Daniel.Wetzler_at_sig.biz>
Date: 9 Mar 2006 06:27:21 -0800
Message-ID: <1141914441.301528.316940@j33g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US