Get column name according to datatype

I want the list of columns whose datatype is "date" from mytable in oracle.
how can i do this. which query is used t fetch such column names?

Junior Poster

126 posts since Nov 2008

Reputation Points: 10

Solved Threads: 2

Try this

select table_name, column_name, data_type
from user_tab_columns
where data_type='DATE'
  and lower(table_name)='mytable'

Newbie Poster

10 posts since Sep 2009

Reputation Points: 10

Solved Threads: 5

This question has already been solved

You