Re: extract stored pl/sql pcode

From: M. Armaghan Saqib <armaghan_at_yahoo.com>
Date: Thu, 27 Jan 2000 12:19:16 +0500
Message-ID: <86ou7b$29fj$1@dolf.netfront.net>

Procedures, functions and packages for a database are stored in dba_source (using varchar2 column)
Triggers for a database are stored in dba_triggers (using long column)

Method 1: Use can extract the code with simple SELECT statements from SQL Plus.

Method 2: My SQL PlusPlus 2.0 (freeware) helps you to do all this very easily. e.g.

SQL> exec s.getpro('give_raise')

| CREATE OR REPLACE
| procedure       give_raise (
|     p_deptno in number,
|     p_raise_percent in number )
| as
| begin
|    update emp set sal = sal + (sal * p_raise_percent * .01)
|    where deptno  = p_deptno;
|
|    commit;
| end give_raise;
| /

You can generate entire source for a database using a single command and store it in a single file.

regards,
M. Armaghan Saqib

+---------------------------------------------------------------
| 1. SQL PlusPlus => Add power to SQL Plus command line
| 2. SQL Link for XL => Integrate Oracle with XL

| 3. Oracle CBT with sample GL Accounting System | Download free: http://www.geocities.com/armaghan/

+---------------------------------------------------------------

immo <iwetzel_at_gmx.de> wrote in message news:86n33j$cqk$1_at_nnrp1.deja.com...
> Hello
>
> How can i extract some/all stored programm units so that i can it
> easy bring back into the database?
>
> Thanks
> Immo
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Posted via news://freenews.netfront.net Complaints to news_at_netfront.net Received on Thu Jan 27 2000 - 01:19:16 CST