(empty log message)
trunk/JunkBox/sql/copyView.sql (diff)| @@ -0,0 +1,6 @@ | ||
| 1 | +select | |
| 2 | + 'create view ' || out_db || '.' || view_name || ' as ' || get_view_text(owner, view_name) || ';' view_sql | |
| 3 | +from all_views | |
| 4 | +join (select upper('test') out_db, upper('hr') in_db from dual) | |
| 5 | +on owner = in_db | |
| 6 | +order by 1; | |
| \ No newline at end of file |
