테이블 찾는 Query
[oracle] 테이블 찾는 쿼리 select a.table_name as name, b.comments as table_comment, round(d.bytes/1024, 0) as tablesize, c.status as storage_limit, c.last_ddl_time from tabs a, user_tab_comments b, user_objects c, user_segments d where a.table_name = b.table_name(+) and a.table_name = c.object_name and c.object_type = 'TABLE' and a.table_name = d.segment_name and d.segment_type = 'TABLE' and b.comments..
DataBase/Oracle
2012. 5. 22. 09:23