Oracle 11g PL/SQL Tutorials

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.

Oracle Skill Tests

• Oracle Database Skills Test
• SQL Skill Test

Related Trainings

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

1. Oracle PL/SQL Tutorial

   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.

2. Download Free Oracle SQL Developer

   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

3. Oracle 11g PL/SQL New Features Author: 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.

4. PL/SQL Native Compilation in Oracle 11g Author: 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

5. Oracle 11g SQL New Features Author: 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