Tutorials
Top 65 PL/SQL Interview Questions & Answers
1) What is PL SQL ? PL SQL is a procedural language which has interactive SQL, as well as procedural programming language constructs...
Read more![Nested Blocks & Variable Scope in Oracle PL/SQL Tutorial [Example]](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_uLuzbWnieacdOz0XwJ0_3OLXGQGW1tdZjRMc7xOUhV_ADP0YflgLTjNWMUA1dhYW-w51Uhcimnq7-tTwPLxLKVHhW_D8VeOjMWCaKPTeatgPXDir1mD01ZaXtTnMO9yrW_-xLv=w680)
Tutorials
Nested Blocks & Variable Scope in Oracle PL/SQL Tutorial [Example]
What is Nested Blocks Oracle? In PL/SQL, each block can be nested into another block. They are referred as a nested block. Nested blocks...
Read more
Tutorials
Oracle PL/SQL Dynamic SQL Tutorial: Execute Immediate & DBMS_SQL
What is Dynamic SQL? Dynamic SQL is a programming methodology for generating and running statements at run-time. It is mainly used to ...
Read more
Tutorials
Oracle PL/SQL Object Types Tutorial with EXAMPLES
What is Object Type in PL/SQL? Object-Oriented Programming is especially suited for building reusable components and complex application...
Read more![Oracle PL/SQL Trigger Tutorial: Instead of, Compound [Example]](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_u1sQbmLbJDZ17l1zPD5ga6WOBDE8qKuG4Meod2cBMhAScltlCQIZgmG9gE4qDRE3wjSgNfroqMGLUZibc255NsASqbELjXsd_rrdIEcVyWQMhxaMMdpTcnciduW6Ixvys2nkI=w680)
Tutorials
Oracle PL/SQL Trigger Tutorial: Instead of, Compound [Example]
What are Triggers in PL/SQL? Triggers are stored programs that are fired automatically when some events occur. The code to be fired can ...
Read more![Oracle PL/SQL Package: Type, Specification, Body [Example]](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqi0Ef_8xanZ5b0F6WDdUGbJig36jFqmXJ6T89e7AxJfDeul8mgdvEPNJ6KMj1NPnycIXxaR2myz34Vt9SB2FySap4phFZugGyUfbMUKgSKeOAyR6VNvcYiiOBGYt0aAK-S1Ha4tIcm_yd/w680/1200px-MySQL.svg.png)
Tutorials
Oracle PL/SQL Package: Type, Specification, Body [Example]
What is Package in Oracle? PL/SQL package is a logical grouping of a related subprogram (procedure/function) into a single element. A ...
Read more
Tutorials
Autonomous Transaction in Oracle PL/SQL: Commit, Rollback
What are TCL Statements in PL/SQL? TCL stands for Transaction Control Statements. It will either save the pending transactions or roll b...
Read more
Tutorials
Oracle PL/SQL BULK COLLECT: FORALL Example
What is BULK COLLECT? BULK COLLECT reduces context switches between SQL and PL/SQL engine and allows SQL engine to fetch the records a...
Read more
Tutorials
Oracle PL/SQL Cursor: Implicit, Explicit, Cursor FOR Loop [Example]
What is CURSOR in PL/SQL? A Cursor is a pointer to this context area. Oracle creates context area for processing an SQL statement whic...
Read more
Tutorials
Oracle PL/SQL Insert, Update, Delete & Select Into [Example]
In this tutorial, we are going to learn how to use SQL in PL/SQL. SQL is the actual component that takes care of fetching and updating...
Read more
Tutorials
Oracle PL/SQL Exception Handling: Examples to Raise User-defined Exception
What is Exception Handling in PL/SQL? An exception occurs when the PL/SQL engine encounters an instruction which it cannot execute due t...
Read more
Tutorials
Oracle PL/SQL Stored Procedure & Functions with Examples
In this tutorial, you are going to see the detailed description on how to create and execute the named blocks (procedures and functions)...
Read more
Tutorials
Oracle PL/SQL WHILE LOOP with Example
What is While Loop? WHILE loop statement works similar to the Basic loop statement except the EXIT condition is at the very beginning o...
Read more
Tutorials
Oracle PL/SQL FOR LOOP with Example
What is For Loop? "FOR LOOP" statement is best suitable when you want to execute a code for a known number of times rather tha...
Read more
Tutorials
Oracle PL/SQL LOOP with Example
What are Loops? Loops allows a certain part of the code in a program to get executed for the desired number of times. In this tutorial...
Read more
Tutorials
Oracle PL/SQL: CASE Statement with Examples
What is CASE Statement? A CASE statement is similar to IF-THEN-ELSIF statement that selects one alternative based on the condition fro...
Read more
Tutorials
Oracle PL/SQL IF THEN ELSE Statement: ELSIF, NESTED-IF
What are Decision-Making Statements? Decision making statements are those who will decide the flow-control of SQL statements based on ...
Read more
Tutorials
Oracle PL/SQL Records Type with Examples
What is Record Type? A Record type is a complex data type which allows the programmer to create a new data type with the desired column ...
Read more
Tutorials
Oracle PL/SQL Collections: Varrays, Nested & Index by Tables
What is Collection? A Collection is an ordered group of elements of particular data types. It can be a collection of simple data type ...
Read more
Tutorials
Oracle PL/SQL Variable Identifiers Tutorial with Examples
What is Identifiers? Identifiers are nothing but a name that is given to a PL/SQL object. The object could be constant, variable, exce...
Read more
