# ÇØ´ç Å×ÀÌºí½ºÆäÀ̽º¿¡ °ü·ÃµÈ ¸ðµç Å×À̺íÀ» °¡Á®¿Â´Ù.
SELECT * FROM TABS
# ÇØ´ç Å×ÀÌºí½ºÆäÀ̽º¿¡ °ü·ÃµÈ ¸ðµç ½ÃÄö½º¸¦ °¡Á®¿Â´Ù.
SELECT * FROM SEQ
# ÇØ´ç Å×ÀÌºí½ºÆäÀ̽º¿¡ °ü·ÃµÈ ¸ðµç ºäÀÇ Á¤º¸¸¦ °¡Á®¿Â´Ù.
SELECT * FROM USER_VIEWS
# ÇØ´ç Å×ÀÌºí¿¡ Ä÷³¸®½ºÆ®¸¦ °¡Á®¿Â´Ù.
SELECT *
FROM USER_TAB_COLUMNS
WHERE TABLE_NAME = Å×À̺í¸í
ORDER BY COLUMN_ID ASC
# ÇØ´ç Å×ÀÌºí½ºÆäÀ̽º¿¡ °ü·ÃµÈ ¸ðµç Æ®¸®°Å¸¦ °¡Á®¿Â´Ü.
SELECT * FROM USER_TRIGGERS
# ÇØ´ç Å×ÀÌºí¿¡ °ü·ÃµÈ Á¦¾à Á¤º¸µéÀ» °¡Á®¿Â´Ù.
SELECT C.TABLE_NAME A1,
SUBSTR(A.COLUMN_NAME,1,15) A2,
DECODE(B.CONSTRAINT_TYPE, 'P','PRIMARY KEY',
'U','UNIQUE KEY',
'C','CHECK OR NOT NULL',
'R','FOREIGN KEY') A3,
A.CONSTRAINT_NAME A4
FROM USER_CONS_COLUMNS A, USER_CONSTRAINTS B, USER_INDEXES C
WHERE A.TABLE_NAME = B.TABLE_NAME
AND A.TABLE_NAME = C.TABLE_NAME
AND A.CONSTRAINT_NAME = B.CONSTRAINT_NAME
AND A.TABLE_NAME =UPPER('Å×À̺í¸í')
ORDER BY 1,2;
#COMMENT Á¤º¸
SELECT
TABLE_NAME, TABLE_TYPE , COMMENTS
FROM USER_TAB_COMMENTS
WHERE TABLE_TYPE LIKE :AS_TABLE_TYPE
AND TABLE_NAME LIKE UPPER(:AS_TABLE_NAME)
AND NVL(COMMENTS, '%') LIKE :AS_TABLE_COMMENT