oracle导出当前job

执行以下语句
SELECT ‘declare job number;’ FROM DUAL;
select ‘BEGIN’ from dual;
SELECT ‘dbms_job.submit(job => job,
what => ‘’’ || what || ‘’’,
next_date => to_date(’’’ ||
to_char(next_date, ‘dd-mm-yyyy hh24:mi:ss’) || ‘’’, ‘‘dd-mm-yyyy hh24:mi:ss’’),
interval => ‘’’ || REPLACE(INTERVAL, ‘’’’, ‘’’’’’) || ‘’’);’
FROM dba_jobs;
SELECT ‘END;’ FROM DUAL;

查询后的结果即为导出语句