PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces.
This tutorial is designed for Software Professionals, who are willing to learn PL/SQL Programming Language in simple and easy steps. PL/SQL is a combination of SQL along with the procedural features of programming languages. It was developed by Oracle Corporation in the early 90's to enhance the capabilities of SQL.Before proceeding with this tutorial, you should have a basic understanding of software basic concepts like what is database, source code, text editor and execution of programs, etc. If you already have an understanding on SQL and other computer programming language, then it will be an added advantage to proceed.
This tutorial will give you great understanding on PL/SQL Programming concepts, and after completing this tutorial, you will be at an intermediate level of expertise from where you can take yourself to a higher level of expertise.This tutorial will give you great understanding on PL/SQL to proceed with Oracle database and other advanced RDBMS concepts.
- Home
- Basic Syntax
- Data Types
- Variables
- Constants and Literals
- Operators
- Conditions
- Loops
- Strings
- Arrays
- Procedures
- Functions
- Cursors
- Records
- Exceptions
- Triggers
- Packages
- Collections
- Transactions
- Date & Time
- DBMS Output
- Object Oriented
- PL/SQL Useful Resources
- Questions and Answers
- Quick Guide
- Useful Resources
- Discussion
No comments:
Post a Comment