Table 목록 가져오기
database/oracle2016.08.05 18:29
1 2 3 4 | SELECT A.TABLE_NAME, B.COMMENTS FROM ALL_TABLES A, ALL_TAB_COMMENTS B WHERE A.TABLE_NAME = B.TABLE_NAME AND A.TABLE_NAME LIKE :table_name || '%' ORDER BY A.TABLE_NAME | cs |
1 2 3 4 | SELECT A.TABLE_NAME, B.COMMENTS FROM ALL_TABLES A, ALL_TAB_COMMENTS B WHERE A.TABLE_NAME = B.TABLE_NAME AND A.TABLE_NAME LIKE :table_name || '%' ORDER BY A.TABLE_NAME | cs |