Hi,
I want to add below line from my existing scheduled job (my existing job has been scheduled in
dba_jobs).
execute immediate 'ALTER SESSION SET NLS_DATE_FORMAT = "YYYY MM DD"';
I was tried dbms_job.what (job in <jobnumber>
what in <plsql script> but there is no luck. So if possible please give the correct solution.
Regards