Interacting with Oracle Database Server using PL/SQL Statements | Oracle PL/SQL Training | Uplatz

In this video, we delve into the fundamentals of Oracle's PL/SQL, focusing on how to effectively retrieve and manipulate data within the database. PL/SQL is a powerful extension of SQL, enabling complex operations such as selecting rows, making changes, and handling transactions with commands like COMMIT and ROLLBACK. Unlike SQL, PL/SQL does not support data definition language (DDL) commands such as CREATE, DROP, or ALTER, nor does it directly handle data control language (DCL) commands. Instead, you’ll need to use dynamic SQL for executing these commands, which we will cover in future tutorials.

We also cover key PL/SQL concepts like cursors, which are essential for managing and processing SQL statements. PL/SQL supports both implicit and explicit cursors—implicit cursors are automatically managed by Oracle, while explicit cursors are defined and controlled by the programmer. Proper use of cursors is crucial for handling data retrieval and manipulation effectively. Additionally, we demonstrate practical examples, such as updating employee salaries and inserting new records into the database. Understanding these operations will help you manage complex data interactions within your PL/SQL programs

PL/SQL includes procedural language elements like conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variable of those types and triggers. It can support Array and handle exceptions (runtime errors). You can create PL/SQL units like procedures, functions, packages, types and triggers, etc.

#PLSQL #OracleDatabase #SQLCommands #DataManipulation #ImplicitCursor #ExplicitCursor #DynamicSQL #DatabaseTransactions #SQLExceptionHandling #OraclePLSQL

Oracle PL/SQL training syllabus:

Overview of PL/SQL
What is PL/SQL? What are the benefits?
PL/SQL Block Structure & Types of Blocks
Writing simple anonymous block
Using SQL*plus to run anonymous block
Creating Script and run it
Quiz
Declaring PL/SQL Variables
About Variables and the syntax
Defining Variables exercise
Guidelines for declaring & initializing variables
Delimiters in string literals (the q' Notation)
Types of variables and data types 1
Types of variables and data types 2
Data Types exercise
Define Variables Using %TYPE
Understating the SELECT statement in PL/SQL
Bind Variables
Quiz
Writing Executable Statements
Inside PL/SQL Block
Inside PL/SQL Block (exercise)
Nested Blocks
SQL & PL/SQL programming Guidelines
Quiz
Interacting with Oracle DB Server
SELECT statement & DML in PL/SQL
SELECT statement & DML in PL/SQL exercise
Understanding Implicit SQL cursor/ SQL Attributes
Implicit SQL cursor exercise
Writing Control Structure
IF Statement Part 1
IF Statement Part 2
Handling nulls in IF statement
CASE expression & CASE Statement
Basic Loop
While Loop
FOR Loop
Nested Loops
Nested Loops and Labels
Continue Statement
Working with Composite Data Types
PL/SQL Records: Programmer method part 1
PL/SQL Records: Programmer method part 2
PL/SQL Records: %ROWTYPE method
Nested PL/SQL Records
INDEX BY tables (Associative arrays)
INDEX BY tables Methods
INDEX BY tables of Records
Nested table
VARRAY
Using Explicit Cursors
Understanding Explicit Cursor
Explicit Cursor exercise
Explicit Cursor Attributes
FOR LOOP Cursor
Cursor with Parameters
FOR UPDATE Clause & CURRENT OF Clause

Creating Procedures
Understanding Procedures and subprograms
Understanding Procedures Syntax
Creating Procedure (IN parameter)
Creating Procedure (OUT parameter)
Creating Procedure (IN OUT parameter)
Comparing the Parameter Modes
Available notations for passing parameters
Using the default option for Parameters
Exception handling in multiple blocks
Using Boolean and PL/SQL records as parameters
Creating Functions
Understanding user-defined functions
Difference between procedures & functions
Creating a function example

-------------------------------------------------------------------------------------------------------

Welcome to Uplatz!
Uplatz is a leading organization providing Management Consulting, IT Training, Virtual employees, and Analytics services.

Uplatz is well known for providing instructor-led training and video-based courses on SAP, Oracle, Salesforce, Cloud Computing, AWS, Microsoft Azure, Big Data, Machine Learning, Python, R, SQL, Google Cloud Platform, Microsoft, IBM, Cisco, Adobe Technologies, DevOps, Project Management, Digital Marketing.

To buy full course, simply contact us at -

----------------------------------------------------------------------------------------------------------