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

Popular posts from this blog

Receive udp packets in android gstreamer -

php - Extract Text from HTTP referer -

matplotlib - PYTHON: Annotate boxes disapear dependant on range -