본문 바로가기
반응형

IT

 (49)
(TIBERO) 티베로 테이블명세서 쿼리(SQL) * SYS계정으로 조회를 해야 함. WITH LIST AS ( SELECT TB.* , C.COMMENTS AS TABLE_COMMENTS FROM ( SELECT A.TABLE_NAME, A.COLUMN_NAME, A.DATA_TYPE, A.DATA_LENGTH, A.NULLABLE, A.COLUMN_ID + 1 AS SORT_NUM, A.DATA_DEFAULT, B.COMMENTS FROM dba_tab_columns A, all_col_comments B WHERE A.OWNER = B.OWNER AND A.TABLE_NAME = B.TABLE_NAME AND A.COLUMN_NAME = B.COLUMN_NAME AND A.OWNER = 'DB명' ) TB LEFT JOIN ALL_TAB_COMME..
반응형

티스토리툴바