oracle10g - Oracle query that returns columns of a certain type -
is possible write oracle query returns columns of type 'timestamp'?
something -
select table_name, column_name dba_tab_columns table_name 'est_%' , column_type = 'timestamp'; //here select columns of type 'timestamp'
i looking wrong table - dba_ind_columns
instead of dba_tab_columns
.
the query pretty straightforward -
select table_name, column_name dba_tab_columns table_name 'est\_%' escape '\' , data_type = 'timestamp(6)';
Comments
Post a Comment