PL/SQL

Learn oracle pl sql tutorial for beginners with examples online. We explained every topic with appropriate example. We are providing oracle pl sql tutorials step by step for Basics, PL/SQL, syntax, data types, variables, constants, records, conditional statements, decision making, iterative statements, loops, cursors, procedures, functions, exception handling, triggers, packages and more.
 
PL/SQL stands for Procedural Language extension of SQL. It was developed by Oracle Corporation in the late 1980s to enhance the capabilities of SQL. It is the procedural extension language for SQL. Here is the list of all oracle pl sql tutorial:

Oracle pl sql tutorial:

Oracle pl sql introduction.
Oracle pl sql introduction. PL/SQL block structure. Architecture of pl/sql. Features of pl sql. Advantages of pl sql.
Oracle pl sql variable example.
Oracle pl sql variable tutorial. Pl sql variable types example. Pl sql variable types. PL/SQL variables naming rules.
Oracle pl sql constants and literals.
Oracle pl sql constants example. Oracle pl sql literals tutorial. Pl sql constants example. Pl sql literals example.
Oracle pl sql hello world program.
Oracle pl sql hello world. Pl sql hello world program. Pl sql program to print hello world. Pl sql stored procedure hello world.
Oracle pl sql if else if statement.
Oracle pl sql if statement. Pl sql if else if statement example. Else if syntax in oracle. Pl sql if then else if examples.
Oracle pl sql switch case statement.
Oracle pl sql case statement examples. Oracle pl/sql case statement example. Switch case in oracle pl/sql. Pl sql switch case syntax tutorial.
Oracle pl sql loop exit when example.
Oracle pl sql loop example tutorial. Oracle pl sql exit loop example. Oracle pl sql loop exit when condition. Oracle pl sql loop exit syntax.
Oracle pl sql while loop example.
Oracle pl sql while loop tutorial. Oracle pl sql while loop example. Oracle pl sql while loop syntax. How to use while loop in pl sql.
Oracle pl sql for in loop example.
Oracle pl sql for in loop example tutorial. Oracle pl sql for in loop syntax. How to use for in loop in pl/sql. Pl sql for in loop reverse example.
Oracle pl sql continue statement example.
Oracle pl sql continue statement example tutorial. Pl sql continue statement. Oracle pl sql continue statement syntax. Pl sql continue statement example.
Oracle pl sql loop label example.
Oracle pl sql loop label example tutorial. Pl sql loop label statement. Oracle pl sql loop label syntax. Pl sql loop label example.
Oracle pl sql goto statement example.
Oracle pl sql goto statement example tutorial. Pl sql goto statement. Oracle pl sql continue goto syntax. Pl sql goto statement restrictions.
Oracle pl sql stored procedure example.
Oracle pl sql stored procedure example. Oracle pl sql stored procedure create syntax. How to pass parameter in a procedure? How to execute stored procedure? How to drop stored procedure?
Oracle pl sql function example.
Oracle pl sql function example. Oracle pl sql function create syntax. How to pass parameter in a function? How to execute function in pl sql? How to drop function in pl sql?
Oracle pl sql implicit, explicit cursor example.
Oracle pl sql cursor tutorial. Oracle pl sql cursor example. Oracle pl sql cursor syntax. Oracle pl sql implicit cursor example. Oracle pl sql explicit cursor example.
Oracle pl sql exception handling example.
Oracle pl sql exception handling example. Exception handling syntax in pl sql. Pl sql raise exception example. Oracle pl sql user defined exception. Oracle predefined exceptions list.
Oracle pl sql triggers example.
Oracle pl sql triggers example. Oracle pl sql trigger syntax. Oracle pl sql trigger types. Create a trigger. Drop a trigger.
Oracle pl sql package example.
Oracle pl sql package example. Parts of a package. Oracle pl sql package specification. Package body or definition, Oracle pl sql package syntax.

Oracle PLSQL interview questions:

PLSQL Interview Questions and Answers.
Oracle PLSQL interview questions. Let us discuss oracle plsql interview questions and answers for freshers & experienced.

 

 


Comments are closed.