'조회' 태그의 글 목록

Oracle 테이블 조회

| DATABASE/ORACLE 2014. 6. 11. 13:49

Posted by S & S

--테이블 조회

SELECT * FROM USER_TABLES;

--컬럼 조회

SELECT * FROM ALL_TAB_COLUMNS WHERE TABLE_NAME = ':TABLE_NAME';

--테이블주석조회

select * from USER_TAB_COMMENTS WHERE table_name = ':TABLE_NAME';

--테이블컬럼주석조회

SELECT * FROM ALL_COL_COMMENTS WHERE table_name = ':TABLE_NAME';

SELECT B.TABLE_NAME,B.COLUMN_NAME

,A.COMMENTS

,B.DATA_TYPE

,B.DATA_LENGTH

,DECODE(B.NULLABLE, 'N','NOT NULL') NULLABLE

FROM DBA_COL_COMMENTS A

,DBA_TAB_COLUMNS B

WHERE A.OWNER = B.OWNER

AND A.TABLE_NAME = B.TABLE_NAME

AND A.COLUMN_NAME = B.COLUMN_NAME

AND B.OWNER = ':OWNER'

AND B.TABLE_NAME = ':TABLE_NAME'

ORDER BY B.COLUMN_ID;

And

| 1 |