Overview of PL/SQL

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

"Language makes it possible for a child to incorporate his parents’ verbal prohibitions,

to make them part of himself....We don’t speak of a conscience yet in the child who is

just acquiring language, but we can see very clearly how language plays an indispensable

role in the formation of conscience.

 

In fact, the moral achievement of man, the whole complex of factors that go into the

organization of conscience is very largely based upon language."   - Selma H. Fraiberg

 

Quote Courtesy: http://www.enotes.com/famous-quotes/language-makes-it-possible-for-a-child-to

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

 

PL/SQL is a language of difference. It is not intended to be a general purpose language. But

it is more used with SQL, the Query Language. By now you will be knowing that in SQL there is no

way you can run a loop, or to do more complex calculations just by using a SQL Query. So PL/SQL

has been built to bridge this gap.

 

In this chapter on Overview of PL/SQL the following are the things we are going to learn:

           

            1. Blocks

               a. Anonymous Blocks

               b. Named Blocks

            2. Variables and Constants

            3. Cursors

               a. Explicit Cursors

               b. Implicit Cursors

              

So here we start our first lesson in PL/SQL.

 

Expect the link for the chapter soon.

 

What is PL/SQL?

As the short form of Programming Language for SQL, the acronym PL/SQL was widely used.

SQL is the language of querying a database with a set of standard syntax or rules. But it lacks basic constructs of a programming language such as a loop or condition evaluator etc. PL/SQL is the bridge that spans between the functionality offered by SQL and a programming language.

This article is intended to be a basic introduction on PLSQL, without any frills. So I think the basic information on the subject is delivered.