Tuesday, November 05, 2013

concating columns and strings in oracle to generate drop table statements / Strings und Spalten in Oracle verbinden um drop Table Statements zu generieren

select 'Drop table ' || table_name || ';' from user_tables where table_name like 'mytablestoDelete%';

No comments: