Oracle中快速生成所有表、触发器删除语句

//快速生成用户下所有表delete 语句
SELECT 'DELETE FROM '|| table_name || ';' FROM USER_TABLES
//执行结果
DELETE FROM PARKSPACE;
DELETE FROM PARKSPACEDATA;
DELETE FROM PIER;
DELETE FROM PROTECTEDPIER;
DELETE FROM REDLINEDATA;
DELETE FROM ROADCENTERLINE;
DELETE FROM ROADCONNECT;
DELETE FROM ROADCONNECTDATA;
DELETE FROM ROADLANE;
DELETE FROM ROADLANEBACK;
DELETE FROM ROADLANEDATA;
DELETE FROM ROADLINK;
DELETE FROM ROADLINKDATA;
DELETE FROM ROADSLOPE;
DELETE FROM ROADSLOPEELEMENT;
DELETE FROM ROADTUNNEL;
DELETE FROM SIDEWALK;
DELETE FROM SIDEWALKDATA;
DELETE FROM TERRAIN;
DELETE FROM TEXT;