|
Step by Step Oracle PL-SQL Tutorial
|
View The Tutorial
This introductory tutorial to PL/SQL will help you to understand the basic concepts of PL/SQL.Please 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. Fell free to print the articles for offline preparation and post any questions in the discussion board.
|
|
|
|
Using Oracle PL/SQL
|
View The Tutorial
PL/SQL stands for Procedural Language/SQL. PL/SQL extends SQL by adding constructs found in procedural languages, resulting in a structural language that is more powerful than SQL. The basic unit in PL/SQL is a block. All PL/SQL programs are made up of blocks, which can be nested within each other. Typically, each block performs a logical action in he program.
|
|
|
|
PL/SQL Good Tutorial
|
View The Tutorial
PL/SQL is the Oracle's extension to SQL with design features of programming languages. The data manipulation and query statements are included in the procedural units of codes. PL/SQL allows the applications to be written in a PL/SQL procedure or a package and stored at Oracle server,
|
|
|
|
PL/SQL Tutorial
|
View The Tutorial
This Oracle PL SQL tutorial teaches you the basics of programming in PL/SQL with appropriate examples. You can use this tutorial as your guide or reference while programming with PL SQL. I will be making this Oracle PL SQL programming tutorial as often as possible to share my knowledge in PL SQL and help you in learning PL SQL better.
|
|
|
|
PL/SQL Tutorial
|
View The Tutorial
PL/SQL is a database-oriented programming language that extends Oracle SQL with procedural capabilities
|
|
|
|
PL/SQL PDF Tutorial
|
View The Tutorial
This section will provide a basic understanding of PL/SQL. This document will briefly cover the main concepts behind
PL/SQL and provide brief examples illustrating the important facets of the language. Most of the information contained
in this section is DIRECTLY extracted from ``PL/SQL User's Guide and Reference'' and all credit should be given to
ORACLE.
|
|
|
|
Basic Structure of PL/SQL
|
View The Tutorial
Pl/Sql is the procedural implementation of sql i.e. you can pass sql statements in procedural format using pl/sql. Normal sql does not have any procedural capabilities moreover you can only pass one statement at a time to Oracle Engine.
|
|
|
|
PL SQL Programming
|
View The Tutorial
This Tutorial contains thousands free scripts and useful Huge material.
|
|
|
|
Oracle PLSQL Tutorial
|
View The Tutorial
This is the first Oracle PLSQL tutorial in a series of introductory tutorials demonstrating how you can use PLSQL to make your Oracle systems better, faster and smarter.
|
|
|
|
PL/SQL WIKI
|
View The Tutorial
PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's proprietary procedural extension to the SQL database language, used in the Oracle database. Some other SQL database management systems offer similar extensions to the SQL language. PL/SQL's syntax strongly resembles that of Ada, and just like Ada compilers of the 1980s the PL/SQL runtime system uses Diana as intermediate representation.
|
|
|
|
PL/SQL - oracle.com
|
View The Tutorial
PL/SQL is an imperative 3GL that was designed specifically for the seamless processing of SQL commands. It provides specific syntax for this purpose and supports exactly the same datatypes as SQL.
|
|
|
|
PL/SQL FAQS
|
View The Tutorial
SQL is a declarative language that allows database programmers to write a SQL declaration and hand it to the database for execution. As such, SQL cannot be used to execute procedural code with conditional, iterative and sequential statements. To overcome this limitation, PL/SQL was created.
|
|
|
|
PL/SQL Developer 7.1
|
View The Tutorial
PL/SQL Developer is an Integrated Development Environment that is specifically targeted at the development of stored program units for Oracle Databases.
|
|
|
|
PL/SQL User's Guide and Reference
|
View The Tutorial
This chapter surveys the main features of PL/SQL and points out the advantages they offer. It also acquaints you with the basic concepts behind PL/SQL and the general appearance of PL/SQL programs. You see how PL/SQL bridges the gap between database technology and procedural programming languages.
|
|
|
