Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Introduction to Oracle PL/SQL

1 Reviews

Course type: Online Instructor led Course

Platform: Skype

Course ID: 27582

Course type: Online Instructor led Course

Platform: Skype

Students Interested 0 (Seats Left 0)

1 Reviews

About the Course

This tutorial is designed for Software Professionals/students, who are willing to learn PL/SQL Programming Language in simple and
easy steps. This course will give you great understanding on PL/SQL Programming concepts, and after completing this
course, you will be at intermediate level of expertise from where you can take yourself to higher level of expertise.

Topics Covered

1.Basics of PL/SQL
PL/SQL architecture
PL/SQL and SQL*Plus
PL/SQL Basics, Variables, Constants, data types & error handling
PL/SQL wrapper utility
2.PL/SQL structures
Simple blocks
Control structures
PL/SQL records
Recognizing the Basic PL/SQL Block and Its Sections
Describing the Significance of Variables in PL/SQL
Distinguishing Between PL/SQL and Non-PL/SQL Variables
Declaring Variables and Constants
Executing a PL/SQL Block
3.Stored procedures, functions and packages
Basics of stored procedures
Basics of functions
Basics of packages
Defining stored procedures & functions
Function and stored procedures prototypes
Passing arguments to functions and stored procedures
Recompiling functions and stored procedures
Pinning packages in the SGA with dbms_shared_pool.keep
Package forward declaration
Package dependency
Package overloading
Listing package information
4.Error checking – exception handling
Defining exceptions
Using the when others clause
Ensuring complete error checking
Passing error messages to calling routine
Boolean logic in PL/SQL
5.Control Structures
Constructing an IF Statement
Constructing and Identifying Different Loop Statements
Controlling Block Flow Using Nested Loops and Labels
If-then-else structure
Testing for numbers characters and Booleans
For loop
While loop
6.Nested blocks in PL/SQL
Creating nested blocks
Understanding scope in nested blocks
7.Cursors in PL/SQL
Cursor basics
Using a cursor for a multi-row SQL query
8.Triggers in PL/SQL
Triggers and database events
Defining a trigger
Timing a trigger
Enabling and disabling a trigger
9.Dynamic SQL in PL/SQL
Introduction to the dbms_sql package
Creating a dynamic SQL statement
10.PL/SQL tables:
Defining PL/SQL tables
Reasons to use PL/SQL tables
Populating a PL/SQL table
Retrieving from a PL/SQL table
11.Bulking in PL/SQL:
Bulk queries
Bulk DML (forall statement)
Using cursor attributes
Analyzing impact of bulk operations

Who should attend

-Students willing to upgrade their skill set.


Basic understanding of database concepts and SQL.

What you need to bring

Inclination to learn new concepts."

Key Takeaways

Write a PL/SQL block using all elements of block structure.
Write PL/SQL statements using lexical units, declared variables, and assignment statements.
Use control structures to loop, branch, and jump.
Use PL/SQL named exceptions and user-defined exceptions.
Use explicit cursors,triggers,packages,procedures,functions
Bulk Processing

Date and Time

Not decided yet.

Students also enrolled in these Courses

About the Trainer

Shivangi Sharma picture

5 Avg Rating

6 Reviews

7 Students

3 Courses

Shivangi Sharma

B.Tech from NIT having 7 yrs of IT experience

1 Years of Experience

I have more than 7 years of IT experience on UNIX and Oracle SQL and PL/SQL programming. I have been teaching UNIX and Oracle for past one year as a full time trainer.

Student Feedback


Average Rating





I am working in an MNC and needed to learn PL/SQL basics. Shivangi has taught all basic concepts with project based scenarios and helped me in my work as well. She has provided proper guidance for OCA preparation.


Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for Oracle Database Post your requirement now


Submit your enquiry for Introduction to Oracle PL/SQL

Please enter valid question or comment

Please select a category

No matching category found.

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Shivangi

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on, to fulfill their learning requirements across 1,000+ categories. Using, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more