Table metadata in Oracle


Normally I work in SQL Server when I am dealing with relational data but on my current project one of our primary systems uses Oracle as its back end. In order to quickly generate a list of column names for use in an access request, I need to interrogate the table metadata and I cannot recall the way to do this on Oracle.

Search terms

oracle column list query

Helpful link


I was reminded to use sys.all_tab_columns to get this information.

By Paul Shippy

Christian software engineer and homeschooling dad

Leave a Reply

Your email address will not be published. Required fields are marked *