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_at_dolf.netfront.net>
> 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 - 08:19:16 CET
Date: Thu, 27 Jan 2000 12:19:16 +0500
Message-ID: <86ou7b$29fj$1_at_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
+--------------------------------------------------------------- [Quoted] | 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 - 08:19:16 CET