RE: Source code of objects

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Mon, 07 May 2001 10:30:54 -0700
Message-ID: <F001.002FB09D.20010507102805@fatcity.com>

> -----Original Message-----
> From: Brijesh Lal [mailto:lal_brijesh_at_yahoo.com]
>

>   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 Received on Mon May 07 2001 - 12:30:54 CDT