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'

Leave a Reply

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

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.