Web Recipes

SELECT A.COLUMN_ID, A.COLUMN_NAME, A.DATA_TYPE, A.DATA_LENGTH, A.NULLABLE, B.COMMENTS FROM  ALL_TAB_COLUMNS A, ALL_COL_COMMENTS B WHERE A.TABLE_NAME = B.TABLE_NAME AND  A.COLUMN_NAME = B.COLUMN_NAME AND  A.TABLE_NAME =  테이블 이름 ORDER   BY  A.TABLE_NAME, A.COLUMN_ID ;

SELECT A.TABLE_NAME, B.COMMENTS FROM  ALL_TABLES A, ALL_TAB_COMMENTS B WHERE   A.TABLE_NAME = B.TABLE_NAME ORDER   BY  A.TABLE_NAME ;