WITH ALL_TAB_PRIMARY_KEY AS (
\n SELECT — \ud14c\uc774\ube14\uc758 PK\uceec\ub7fc
\n CONS.OWNER, COLS.TABLE_NAME, COLS.COLUMN_NAME, COLS.POSITION, CONS.STATUS, ‘P’ AS PRIMARY_KEY
\n FROM ALL_CONSTRAINTS CONS, ALL_CONS_COLUMNS COLS
\n WHERE CONS.CONSTRAINT_TYPE = ‘P’
\n AND CONS.CONSTRAINT_NAME = COLS.CONSTRAINT_NAME
\n –AND CONS.TABLE_NAME = ‘(YOUR_TALBE_NAME)’
\n)
\nSELECT A.OWNER,A.TABLE_NAME,B.COMMENTS AS TABLE_DESC
\n ,A.COLUMN_NAME,C.COMMENTS AS COLUMN_DESC,D.PRIMARY_KEY
\n ,A.COLUMN_ID,A.DATA_TYPE,A.DATA_LENGTH,A.DATA_SCALE,A.NULLABLE
\nFROM ALL_TAB_COLUMNS A
\n ,ALL_TAB_COMMENTS B
\n ,ALL_COL_COMMENTS C
\n ,ALL_TAB_PRIMARY_KEY D
\nWHERE A.OWNER = ‘(OWNER_NAME)’
\n AND A.OWNER = B.OWNER AND A.TABLE_NAME = B.TABLE_NAME
\n AND A.OWNER = C.OWNER(+) AND A.TABLE_NAME = C.TABLE_NAME(+) AND A.COLUMN_NAME = C.COLUMN_NAME(+)
\n AND A.OWNER = D.OWNER(+) AND A.TABLE_NAME = D.TABLE_NAME(+) AND A.COLUMN_NAME = D.COLUMN_NAME(+)
\n AND A.TABLE_NAME IN ( ‘(YOUR_TALBE_NAME)’ )<\/p>\n","protected":false},"excerpt":{"rendered":"
WITH ALL_TAB_PRIMARY_KEY AS ( SELECT — \ud14c\uc774\ube14\uc758 PK\uceec\ub7fc CONS.OWNER, COLS.TABLE_NAME, COLS.COLUMN_NAME, COLS.POSITION, CONS.STATUS, ‘P’ AS PRIMARY_KEY FROM ALL_CONSTRAINTS CONS, ALL_CONS_COLUMNS COLS WHERE CONS.CONSTRAINT_TYPE = ‘P’ AND CONS.CONSTRAINT_NAME = COLS.CONSTRAINT_NAME –AND CONS.TABLE_NAME = ‘(YOUR_TALBE_NAME)’ ) SELECT A.OWNER,A.TABLE_NAME,B.COMMENTS AS TABLE_DESC ,A.COLUMN_NAME,C.COMMENTS AS COLUMN_DESC,D.PRIMARY_KEY ,A.COLUMN_ID,A.DATA_TYPE,A.DATA_LENGTH,A.DATA_SCALE,A.NULLABLE FROM ALL_TAB_COLUMNS A ,ALL_TAB_COMMENTS B ,ALL_COL_COMMENTS C ,ALL_TAB_PRIMARY_KEY D WHERE A.OWNER = ‘(OWNER_NAME)’ … Continue reading \ud14c\uc774\ube14\uc758 \uceec\ub7fc\/\ucf54\uba58\ud2b8\/\uceec\ub7fc\uc0ac\uc774\uc988\/PK \ubf51\uc544\ub0b4\uae30<\/span>