오라클 TABLE, FUNCTION, PROCEDURE 검색

오라클 TABLE, FUNCTION, PROCEDURE 검색

** TABLE 

SELECT *

  FROM TAB;

SELECT * 

  FROM USER_OBJECTS

 WHERE OBJECT_TYPE = 'TABLE'

-- AND OBJECT_NAME = 'TABLE_NAME';

** FUNCTION 

SELECT *

  FROM USER_OBJECTS

 WHERE OBJECT_TYPE = 'FUNCTION'

-- AND OBJECT_NAME = 'FUNCTION_NAME';

** PROCEDURE

SELECT * 

  FROM USER_OBJECTS

 WHERE OBJECT_TYPE = 'PROCEDURE'

-- AND OBJECT_NAME = 'PROCEDURE_NAME';

** SEQUENCE

SELECT *

  FROM USER_OBJECTS

 WHERE OBJECT_TYPE = 'SEQUENCE'