테이블정의서 (1) 썸네일형 리스트형 Oracle data dictionary를 이용한 테이블의 컬럼 정의 SQL SELECT a.column_name, c.comments AS column_name_ko, CASE WHEN data_type = 'VARCHAR2' THEN 'VC2' WHEN data_type = 'NUMBER' THEN 'NUM' ELSE data_type END || '(' || data_length || ')' AS TYPE, b.key, nullable, data_default AS defalut, c.comments FROM cols a LEFT OUTER JOIN ( SELECT table_name, COLUMN_NAME, 'PK' AS KEY FROM ALL_CONS_COLUMNS WHERE CONSTRAINT_NAME IN (SELECT CONSTRAINT_NAME FROM ALL_C.. 이전 1 다음