Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
Show all tables that have a specific column name (Oracle)
SELECT TABLE_NAME FROM USER_TAB_COLUMNS
WHERE COLUMN_NAME = 'ID'
@arianmaykon

This comment has been minimized.

Show comment Hide comment
@arianmaykon

arianmaykon Apr 10, 2012

Maybe you can find some commands here https://gist.github.com/1104227 :)

Maybe you can find some commands here https://gist.github.com/1104227 :)

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