Oracle에서..MySQL의 desc와 같은 결과 가져오기

mysql의 desc의 결과 내용

Field      |       Type     |       Null     |     Key     |  ....
===================================
             |                    |                  |                |


---------------------------------------------------

select t1.table_name, t1.column_name, t1.data_type, t2.pk, t2.nval
from   (
          select table_name,column_name,sum(pk) pk,sum(nullvalue) nval
          from   (
                    select distinct t2.table_name,t1.column_name,
                        decode(t2.constraint_type,'P',1,0) pk,
                        decode(t2.constraint_type,'C',1,0) NUllvalue
                    from   user_cons_columns t1,user_constraints t2
                    where  t2.constraint_type in ('P','C')
            and    t2.constraint_name = t2.constraint_name
            and    t2.table_name = t1.table_name
            and    t1.owner = t2.owner
            and    t1.table_name = '해당테이블'
            --and    t2.owner = '테이블 유저'
            order by t2.table_name,t1.column_name
          )
          group by table_name,column_name
            ) t2,
            (
            select table_name, column_name, data_type
            from   user_tab_cols
            where  table_name = '해당테이블'
            ) t1
where  t1.column_name = t2.column_name(+)
and    t1.table_name = t2.table_name(+)