Follow below get the body of the procedures in Oracle Database:
SQL> SELECT text FROM all_source WHERE name='&name' ORDER BY line;
Get the body of the procedures in Oracle
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...