select dbms_metadata.get_ddl(object_type=>'TRIGGER',NAME=>TRIGGER_NAME) FROM USER_TRIGGERS;plsql develop :exp:tools-export object-trigger 转载于:https://www.cnblogs.com/liudabao123/p/7965858.html