Differentiate between SQL and PL/SQL?

Posted By: Avi

Date: 1 October 2010 12:24:08 PM

Answer:

1. SQL is simpleified statement for Selecting and Manipulating the data. Whereas PL/SQL is a Procedural Language to create applications. 2. SQL executes one statement at a time on the other hand PL/SQL executes a bunch of statements all together as a block code. 3. SQL guides the database by telling what to do but PL/SQL tells the database how to do with the help of the procedure. 4. SQL cannot be embedded in a PL/SQL whereas it is possible to embed PL/SQL within the SQL. 5. SQL is used by RDBMS technologies such as Oracle,Sybase,Access. But Pl/SQL being a procedure oriented language is used to write data centric programs.

Posted By: avibtech

Date: 1 October 2010 12:24:08 PM

Post a better Answer if you have

Name*

E-mail* (Will show your Gravatar icon)

Website

Country

Notify me when new Answers are added

Enter the text as shown in the image

What is the purpose of Triggers?

Triggers are some set of business rules. It consist of some set of commands or statements like Store....

Category: Database

Date: 10/1/2010 10:59:06 AM

What is DKNF?

DKNF is one of the Normalization forms. It is Domain-Key Normal Form(DKNF). According to this normal....

Category: Database

Date: 10/1/2010 10:58:06 AM

Why is De-normalisation Required?

Fully normalized database can only be attained at logical level. Truly normalized databse can not be....

Category: Database

Date: 10/1/2010 10:57:06 AM

What do you mean by normalization?

Basically normalization is a process in realational databse design to organise the data and avoid da....

Category: Database

Date: 10/1/2010 10:56:06 AM

I have 1-year gap between my 10th & 12th. So what should I answer regarding this?

Category: Database

Date: 12/6/2009 5:05:27 AM

View All Questions >>

Signup for our weekly email newsletter

Submit Content