Get the body of the procedures in Oracle

April 8, 2015 brunors

 

Follow below get the body of the procedures in Oracle Database:

SQL> SELECT text FROM all_source WHERE name='&name' ORDER BY line;

 

brunors

Related posts

• August 16, 2023 brunors 0

  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 0

  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...
• May 29, 2023 brunors 0

  Enable online status for all Oracle database datafiles

  I have executed a database migration by transitioning from a physical active data guard to a...