February 6, 2020

Listing Column Names For Oracle Table Without Describe

This approach can use “where COLUMN_NAME like ‘Something%’ too:

select COLUMN_NAME from ALL_TAB_COLUMNS where TABLE_NAME = 'TableName'

Lisa's Home Page