oracle query objects info

sql-oracle-Query objects info.sql

select 
   t0.OWNER
  ,t0.TABLE_NAME
  ,t1.COMMENTS as TABLE_COMMENT
  ,t2.COLUMN_NAME
  ,t3.COMMENTS as COLUMN_COMMENT
  ,t2.DATA_TYPE
  ,t2.DATA_LENGTH
from SYS.ALL_TABLES t0
inner join SYS.ALL_TAB_COMMENTS t1 on
  t0.TABLE_NAME = t1.TABLE_NAME
inner join SYS.ALL_TAB_COLUMNS t2 on
  t0.TABLE_NAME = t2.TABLE_NAME
inner join SYS.ALL_COL_COMMENTS t3 on
  t0.TABLE_NAME = t3.TABLE_NAME
  and
  t2.COLUMN_NAME = t3.COLUMN_NAME
where 
  t0.TABLE_NAME = UPPER('tbl_operation_column')
order by 
  t2.COLUMN_ID;