How to find all tables with a specific column name in Oracle

Simple and effective:

SELECT TABLE_NAME FROM USER_TAB_COLUMNS
WHERE COLUMN_NAME='PARTNO'

ed0cea9d-0d01-4f40-8ced-b1a5335f9ccd|0|.0

Categories: Databases

Posted by wizgod on Tuesday, August 17, 2010 11:36 PM

E-mail | Kick it! | DZone it! | del.icio.us

Permalink | Comments (0) | Post RSS RSS comment feed

How to find all tables with a specific column name in MS SQLSimple and effective: SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE...Get display name of logged in user in InfoPathdisplay name, username, login, active directory, InfoPathCreating stored procedures in Oracle/PLSQLThe syntax for a procedure is: CREATE [OR REPLACE] PROCEDURE procedure_name [ (parameter [,par...

Comments

Add comment

Name*
E-mail*
Website
Country Country flag

b i u quote

Notify me when new comments are added

Byte My Data