Adding name of the table in the output from multiple tables


select 'select '||''''||owner||'.'||TABLE_NAME||''''||','||' a.* from '||owner||'.'||TABLE_NAME||' a ;' from dba_tables where TABLE_NAME like '%VERSION_LEVEL%'
order by owner, table_name;

This is useful when the output is single row and we are running on multiple tables

No comments:

Post a Comment