10월 2009 - 어느용

오라클에서 컬럼 명들을 가지고 오는 쿼리

select *
from dba_col_comments
where 1=1
and owner='anyxxxxxx'
and comments is NULL
and able_name not like 'BIN$%'
order by table_name

select *

from dba_col_comments

where 1=1

and owner='anyxxxxxx'

and comments is NULL

and able_name not like 'BIN$%'

order by table_name

select *
from dba_tab_comments
where 1=1
and owner='anyxxxxxx'
and comments is NULL
and table_name not like 'BIN$%'
order by table_name

select *

from dba_tab_comments

where 1=1

and owner='anyxxxxxx'

and comments is NULL

and table_name not like 'BIN$%'

order by table_name