Search This Blog

Sunday, November 28, 2010

How to Find Column Name in Oracle dba_tab_cols

Use Following Query to find the column name in Oracle

SELECT * FROM dba_tab_cols WHERE table_name LIKE 'FA%' AND column_name LIKE 'PO%'

No comments:

Post a Comment