set long 10000 set heading off set trimspool on set lines 300 set longchunksize 300 spool mytrigger.sql exec dbms_metadata.set_Transform_param(dbms_metadata.session_transform,'SQLTERMINATOR',true); select dbms_metadata.get_ddl('TRIGGER','MYTRIGGER','SCOTT') FROM DUAL;
No comments:
Post a Comment