Concatenation and Select statements

[ChrisQuick]

Is it possible to do something like this:

SELECT 'SELECT ' ||COLUMN_NAME|| ',' ||TABLE_NAME|| ' FROM ROLE_TAB_PRIVS;'
FROM ALL_TAB_COLUMNS WHERE OWNER_NAME='myname';

I keep getting a "invalid column" error.

 

[carp]

There is no owner_name column in all_tab_columns. Try
... WHERE owner='myname';