Re: Problem qith querying View source

From: Daniel Wetzler <Daniel.Wetzler_at_sig.biz>
Date: 9 Mar 2006 07:14:21 -0800
Message-ID: <1141917261.138048.124040@v46g2000cwv.googlegroups.com>

Hi there,

I found an option which works on console :

If one sets the long value it is possible to get the whole text on the console :

SQL> set long 1000
SQL> select text from dba_views where view_name = 'DBA_REGISTRY';

TEXT

---

SELECT r.cid, r.cname, r.version,

       SUBSTR(dbms_registry.status_name(r.status),1,11),
       TO_CHAR(r.modified,'DD-MON-YYYY HH24:MI:SS'),
       r.namespace, i.name, s.name, r.vproc,
       DECODE(bitand(r.flags,1),1,'REQUIRED',NULL), r.pid,
       dbms_registry.schema_list_string(r.cid)

FROM registry$ r, user$ s, user$ i
WHERE r.schema# = s.user# AND r.invoker#=i.user#

SQL> Received on Thu Mar 09 2006 - 09:14:21 CST