SQL & PL/SQL

Hi,

Is there a solutuion on how can i get list of columns used in all tables where in the column names are to be specified dynamically for all tables under a owner.

For example :-

SELECT TABLE_NAME , COLUMN_NAME

FROM   ALL_TAB_COLUMNS

WHERE  COLUMN_NAME LIKE '%EMP_NUM%' ;

This will give me the list of tables having the columns EMP_NUM which i'm explicitly mentioning.

How can i make the column names dynamic , i.e for all columns in all tables

for a schema.