> -----Original Message-----
> From: Brijesh Lal [mailto:[EMAIL PROTECTED]]
>
> I don't remember the view in which source code is
> stored for example source code of procedures,
> functions or even database link. Can anyone tell me in
> which view is the source code stored
For procedures, functions, packages:
select text
from dba_source
where owner = 'OBJECT_OWNER'
and name = 'OBJECT_NAME'
order by type, line ;
For database links:
select *
from dba_db_links ;
For views:
set long 4000 (or some other high number)
select text
from dba_views
where owner = 'VIEW_OWNER'
and view_name = 'VIEW_NAME' ;
------
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com
