Member Avatar for MARKAND911

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?

  • 2 Contributors
  • 1 Reply
  • 87 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by babyDBA
Member Avatar for babyDBA

Try this

select table_name, column_name, data_type
from user_tab_columns
where data_type='DATE'
  and lower(table_name)='mytable'
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.