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

php - Wordpress website dashboard page or post editor content is not showing but front end data is showing properly -

How to get the ip address of VM and use it to configure SSH connection dynamically in Ansible -

javascript - Get parameter of GET request -