Follow below get the body of the procedures in Oracle Database:
SQL> SELECT text FROM all_source WHERE name='&name' ORDER BY line;
Related posts
-
Oracle Database Growth Monitoring Script
The Oracle Database Growth Monitoring Script is a tool designed to track and analyze the growth... -
May 29, 2023 brunors Comments Off on PL/SQL package SYS.DBMS_BACKUP_RESTORE version is not currentPL/SQL package SYS.DBMS_RCVMAN version 19.10.00.00 is too old
PL/SQL package SYS.DBMS_BACKUP_RESTORE version is not currentPL/SQL package SYS.DBMS_RCVMAN version 19.10.00.00 is too old
Recently, I undertook the task of upgrading an Oracle database from version 19.10 to 19.18. As... -
Enable online status for all Oracle database datafiles
I have executed a database migration by transitioning from a physical active data guard to a...
… [Trackback]
[…] Read More to that Topic: techdatabasket.com/2015/04/08/get-the-body-of-the-procedures-in-oracle/ […]
… [Trackback]
[…] Here you can find 70618 additional Info on that Topic: techdatabasket.com/2015/04/08/get-the-body-of-the-procedures-in-oracle/ […]
… [Trackback]
[…] Find More on that Topic: techdatabasket.com/2015/04/08/get-the-body-of-the-procedures-in-oracle/ […]