Search This Blog

Showing posts with label Find Column Name in Oracle. Show all posts
Showing posts with label Find Column Name in Oracle. Show all posts

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%'