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 commented Nov 23, 2016

Thanks bro!

@TCS-markp

This comment has been minimized.

Copy link

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
You can’t perform that action at this time.