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