Course Highlights

• Introduction to PL/SQL

• Cursors - Implicit Cursors, Explicit Cursors

• Stored Procedures - Procedures, Function, Triggers

• Exception Handling

• Packages

Why to take this course at Learnmet?

• Lifetime course access with updates

• Access on any device - Mobile, Desktop, Tablet and Laptop Click Download Android App

• Take personal notes for every section and view later

• View session recordings for all live classes (For instructor-led courses)

• Dedicated private discussion board for every course

• Send private questions to the author during course view

• Receive a digital sharable certificate of Completion

Detail Description

Curriculum

• Introduction to PL/SQL

  Need of PL/SQL and basic information

  • PL/SQL Block, Structure of PL/SQL Block

  • Data Types in PL/SQL

  • Programming Constructions

  • Composite Data Types

  • Sample Programs

• Cursors

  Work Area to store tables information

  • Purpose of Cursors, Types of Cursors

  • Attributes and Commands used in Explicit Cursors

  • Cursor For Loop

  • Cursor Parameters

  • Sample Programs