Snippet Name: Get table with named columns Description: Used to obtain the table names which contain certain columns. Super handy! Comment: (none) Language: PL/SQL Highlight Mode: PLSQL Last Modified: February 27th, 2009
Description: Used to obtain the table names which contain certain columns. Super handy!
SELECT b.object_name FROM sys.col$ a, user_objects b WHERE a.name = 'WBS_ID' AND a.obj# = b.object_id AND b.object_type = 'TABLE'
