MyPhatshala

PL/SQL (Oracle)

Procedural programming inside the Oracle database.

Intermediate4 modules14 lessonsFree · no sign-up
0 of 14 lessons published
View syllabus

Syllabus

01 BasicsBlocks and variables. 4 lessons
  1. 1.1What is PL/SQL?Coming soon
  2. 1.2PL/SQL block structureComing soon
  3. 1.3Variables, constants and data typesComing soon
  4. 1.4Control structures and loopsComing soon
02 CursorsProcessing rows one by one. 3 lessons
  1. 2.1Implicit and explicit cursorsComing soon
  2. 2.2Cursor FOR loopsComing soon
  3. 2.3Parameterised cursorsComing soon
03 SubprogramsReusable code in the database. 3 lessons
  1. 3.1ProceduresComing soon
  2. 3.2FunctionsComing soon
  3. 3.3PackagesComing soon
04 Errors and TriggersHandling events. 4 lessons
  1. 4.1Exception handlingComing soon
  2. 4.2TriggersComing soon
  3. 4.3Collections and recordsComing soon
  4. 4.4Bulk collect and FORALLComing soon