관리 메뉴

Data Modeling Evangelist Kaien Kim's Blog

참조 Object조회하기 본문

DATA/Oracle

참조 Object조회하기

2013. 2. 13. 09:35

1. Oracle에서 해당 테이블을 참조하는 Object를 조회

SELECT 
* 
FROM    SYS.DBA_DEPENDENCIES 
WHERE   REFERENCED_NAME='ORDER_NEWSPAPER';

2. 테이블 목록 조회 

SELECT 
OBJECT_NAME 
FROM    USER_OBJECTS
WHERE    OBJECT_TYPE ='TABLE'
ORDER BY OBJECT_NAME;

3. 컬럼 목록 조회 

SELECT
  A.TABLE_NAME
, A.COLUMN_NAME
, A.DATA_TYPE
, A.DATA_LENGTH
, A.DATA_PRECISION
, A.DATA_SCALE
, A.NULLABLE  
, B.COMMENTS
FROM    COLS A,  
        ALL_COL_COMMENTS B 
WHERE   A.TABLE_NAME    = B.TABLE_NAME
AND     A.COLUMN_NAME   = B.COLUMN_NAME
AND     A.TABLE_NAME    LIKE 'TSN_PAX_NM'
AND     B.OWNER         = 'RIT'
ORDER BY A.TABLE_NAME, A.COLUMN_ID;