Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: aac, 44100 Hz
Language: English | VTT | Size: 322 MB | Duration: 51m
Learn about DBMS_SCHEDULER, and it's components.
What you'll learn
Learn about Oracle Chains
Create Oracle Programs
Oracle Scheduler and It's components
Basic knowledge about Oracle PLSQL
In this course, we will automate the file processing system. If you are a PLSQL programmer and wanted to learn about Oracle Schedular and Chains, this course is for you. We will work on the SQL Developer and Teal somes and solve a real-world scenario. We will write PL/SQL Procedure, Create Programs, and Learn about Oracle Chains and its step and rule.
Oracle Database provides advanced scheduling capabilities through Oracle Scheduler (the Scheduler). The Scheduler offers far more functionality than the DBMS_JOB package, which was the previous Oracle Database job scheduler. This chapter discusses briefly how you can take statements created with DBMS_JOB and rewrite them using DBMS_SCHEDULER, which is the package that you use to configure and operate the Scheduler. (Source: Oracle)
You will also learn Oracle chains - are the means by which you can implement dependency-based scheduling, in which jobs are started depending on the outcomes of one or more previous jobs.
PL/SQL Stored Procedure
Who this course is for: