PL/SQL
3 posts
Process and read xlsx from PL/SQL
To read a XLSX-file from PL/SQL can be a bit challenging. One option is to rename the file to .ZIP and then process it from from there. An XLSX-file…
DBMS_SCHEDULER
When you back in the day wanted to schedule or run something in the backgound you used DBMS_JOB. With the beginning of release 10g of the database…
DBMS_JOB
Submitted/scheduled job can be found in: Running jobs can be found in: Remove a job: DBMS_JOB have been deprecated and replaced by DBMS_SCHEDULER…