Category: PL/SQL

Overview
PL/SQL is the short form of Procedural Language/Structured Query Language. It is primarily used to process SQL commands. It is a combination of SQL and standard programming-language features embedded in Oracle Database.  PL/SQL code are compiled and store within Oracle database which allows functions and procedures to be easily shared.  PL/SQL supports variables, conditional statements, cursors, collections, loops, triggers, exceptions and error handling.

Training Objective

This category provides Self-Study PL/SQL tutorials. PL/SQL is one of the most important and must needed skill for developers who are working with Oracle. PL/SQL Training section will be based on the latest Oracle 11g version. In this section, we have used command prompt and SQL Developer for the practice samples. 

Target Audience
PL/SQL tutorials provides concrete self-learning platform for beginners and will strengthen the fundamentals for intermediate database professionals.

Related Trainings

Oracle 9i Training
Oracle 10g Training
Oracle 11g Training
Oracle Apps 1i

Oracle 11g SQL New Features

Saurabh Gupta
In continuation to my last tutorial on PL/SQL enhancements, I have compiled the list of enhancement pertaining to SQL. Similar to PL/SQL, Oracle had done considerable enhancements in SQL to raise performance level from instrumental to advisory. In the tutorial, we shall go through the performance oriented features, fresh additions and language enhancements. Performance improvements a. Alter table to add columns with default value In Oracle 11g, we can alter a table to add a column with a default value. Earlier, a developer used to update the value for the… Read More

PL/SQL Native Compilation in Oracle 11g

Saurabh Gupta
During the introduction of Objects and Types in Oracle 8 release, PL/SQL was referred as procedural and object oriented language. While Oracle 9i and 10g were more concentrated on the sharpening of the object oriented model of Oracle, Oracle 11g aims at evolving PL/SQL from interpreted language to natively compiled language. In the tutorial, we shall see the changes made to achieve native compilation and its post application effects. Interpreted to Native Compilation: A Tour Native compilation of program units was first introduced in Oracle 9i release 1. Introduction of… Read More

Oracle 11g PL/SQL New Features

Saurabh Gupta
The tutorial lists the major PL/SQL additions and enhancements covered in Oracle 11g. The features described here are based on their utility in a development environment. SQL* Plus Stepped Down and Passwords made Case Sensitive SQL* Plus is no more the part of Oracle home family. This step has been taken to recommend the use of SQL Developer. SQL Developer version 3.0 is the latest release from Oracle, in which all the earlier reported bugs were resolved. Besides, developers can still optionally setup SQL* Plus environment on command line prompt.… Read More

Oracle PL/SQL Tutorial

Exforsys
This introductory tutorial to PL/SQL will help you to understand the basic concepts of PL/SQL.  Review the following tutorials and practice the sample SQL Statements on your local Oracle Database. Please note that you must learn these basic things before we actually start getting in to Advanced Oracle Concepts in the OCP Certification track. SQL, PLSQL, and SQL SQL *Plus – Introduction We are excited to let you know that we are launching shortly The New Technology Learning Series. We will be starting with Oracle 9i: SQL, PLSQL, and SQL… Read More

Download Free Oracle SQL Developer

Exforsys
Download Free Oracle SQL Developer Oracle SQL Developer is a free graphical tool that enhances productivity and simplifies database development tasks. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, edit and debug PL/SQL statements, manipulate and export data, and view and create reports. You can connect to Oracle databases, and you can connect to selected third-party (non-Oracle) databases, view metadata and data, and migrate these databases to Oracle. Oracle SQL Developer 3.0 Early Adopter 4 now available. Be a part of the Early Adopter… Read More