Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Oracle: Check if a column exists in a table
select column_name as found
from user_tab_cols
where table_name = '__TABLE_NAME__'
and column_name = '__COLUMN_NAME__'
@oscdeveloper

This comment has been minimized.

Copy link

@oscdeveloper oscdeveloper commented Nov 23, 2016

Thanks bro!

@TCS-markp

This comment has been minimized.

Copy link

@TCS-markp TCS-markp commented Nov 13, 2019

Same! Thank you!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment