Get code for all procedure, function and package from user_objects : USER_OBJECTS « System Tables Views « Oracle PL / SQL






Get code for all procedure, function and package from user_objects

    
SQL>
SQL> set termout off
SQL> set heading off
SQL> set feedback off
SQL> set linesize 50
SQL>
SQL> select '@getcode ' || object_name
  2  from user_objects
  3  where object_type in ( 'PROCEDURE', 'FUNCTION', 'PACKAGE' )
  4  /

@getcode DONTCOUNTSP
@getcode DO_COMMIT
@getcode MY_TO_DATE
@getcode EXITFUNC
@getcode FACTORIAL
@getcode EMP_CHANGE_S
@getcode EMP_DEPT_PROCS
@getcode ERASE
@getcode GETEMPBLDGNAME
@getcode ASSIGNEMPTOBLDG
@getcode DEBUG
@getcode ADD_MON
@getcode RAISE

@getcode ASSERT
@getcode MAKE_MYTABLE
@getcode WRITE_NAME
@getcode HELLO
@getcode STATE_PACKAGE
@getcode GET_NEXT_OBJECT_TO_COMPILE
@getcode COMPILE_SCHEMA
@getcode PRINT_TABLE
@getcode SHOW_SPACE
@getcode DEBUG_TIMER
@getcode P
@getcode PEOPLE
@getcode P_ADD_PROD

@getcode P_ADD_EMPS
@getcode P_ADD_ORDERS
@getcode MEASURE_USAGE
@getcode SHOW_IOT_SPACE
@getcode FILE_DUMP
@getcode COMPANY_LISTING
@getcode PIVOT
@getcode VIRTUAL_TABLE
@getcode REMOVE_CONSTANTS
SQL>
SQL>
SQL> set termout off
SQL> set heading off
SQL> set feedback on
SQL>
SQL> select '@' || object_name
  2  from user_objects
  3  where object_type in ( 'PROCEDURE', 'FUNCTION', 'PACKAGE' )
  4  /

@DONTCOUNTSP
@DO_COMMIT
@MY_TO_DATE
@EXITFUNC
@FACTORIAL
@EMP_CHANGE_S
@EMP_DEPT_PROCS
@ERASE
@GETEMPBLDGNAME
@ASSIGNEMPTOBLDG
@DEBUG
@ADD_MON
@RAISE

@ASSERT
@MAKE_MYTABLE
@WRITE_NAME
@HELLO
@STATE_PACKAGE
@GET_NEXT_OBJECT_TO_COMPILE
@COMPILE_SCHEMA
@PRINT_TABLE
@SHOW_SPACE
@DEBUG_TIMER
@P
@PEOPLE
@P_ADD_PROD

@P_ADD_EMPS
@P_ADD_ORDERS
@MEASURE_USAGE
@SHOW_IOT_SPACE
@FILE_DUMP
@COMPANY_LISTING
@PIVOT
@VIRTUAL_TABLE
@REMOVE_CONSTANTS

35 rows selected.

SQL>
SQL> set heading on
SQL> set feedback on
SQL> set linesize 130
SQL> set termout on
SQL>
SQL>

   
    
    
  








Related examples in the same category

1.Query user_objects table
2.Query USER_OBJECTS table by object name
3.Query object_type, object_name from user_objects
4.Query user_objects table for all procedure
5.list all stored procedures: 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'PACKAGE BODY'
6.Query user_objects in PL/SQL
7.Query a view in user_objects table for a view just created
8.Query user_objects for invalid package body
9.Query user-objects for stored procedure
10.Query user_objects for trigger
11.Query user_objects for invalid view
12.Query all INVALID objects from user_objects table
13.Query user_objects table for stored procedure before and after recompile
14.If procedure is valid
15.A procedure with dependencies
16.Check package status
17.Check new created tables in user_objects
18.Finding, Validating, and Describing Packages
19.Get object id for created table
20.Show the procedure is marked invalid **
21.Show the status of a procedure
22.To find out what procedures and functions you have created, use the following SQL query: