Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Query user_objects for your functions and procedures

SQL> SQL> create table t ( x int ); Table created. SQL> SQL> create or replace view v as select * from t; View created. SQL> SQL> create or replace procedure p   2  as   3  begin   4          for x in ( select * from t )   5          loop   6                  null;   7          end loop;   8  end;   9  / SQL> SQL> create or replace function f return number   2  as   3          countValue number;   4  begin   5          select count(*) into countValue from t;   6          return countValue;   7  end;   8  / Function created. SQL> SQL> select object_name, object_type, status from user_objects   2  where rownum < 10   3  / OBJECT_NAME -------------------------------------------------------------------------------- OBJECT_TYPE         STATUS ------------------- ------- MYSTATS INDEX               VALID MYSTATS TABLE               VALID S SEQUENCE            VALID OBJECT_NAME -------------------------------------------------------------------------------- OBJECT_TYPE         STATUS ------------------- ------- P_ADD_ITEMS PROCEDURE           INVALID WORKING_CUSTOMERS TABLE               VALID ADDTUPLE3 PROCEDURE           INVALID OBJECT_NAME -------------------------------------------------------------------------------- OBJECT_TYPE         STATUS ------------------- ------- P_ADD_ORDERS PROCEDURE           INVALID P_ADD_PROD PROCEDURE           INVALID UPDATE_PRODUCT_PRICE PROCEDURE           INVALID 9 rows selected. SQL> SQL> drop table t; Table dropped.