difference between Sql(Structured query lanquage) and pl/sql

SQL is a query language that allows you to issue a single query or execute a single insert/update/delete. PL-SQL is Oracle's "Programming Langugage" SQL, which allows you to write a full program (loops, variables, etc.) to accomplish multiple selects/inserts/updates/deletes. You should learn SQL first, then move on to PL-SQL. You will probably need both to be an Oracle DBA.


SQL tells the database what to do (declarative), not how to do it. In contrast, PL/SQL tell the database how to do things (procedural).

Refer the following link.
http://www.plsql-tutorial.com/

Rajeshk, if this helps please login to Mark As Answer. | Alert Moderator

Hi Deep,

Thank You For your Replay can ms- sql users use this(pl/sql)? or oracle users only and also give me a simple pl/sql example

Thanks&Regards
rajeshkommireddy@gmail.com

Rajeshk, if this helps please login to Mark As Answer. | Alert Moderator

hi rajesh,
pl/sql was designed by the oracle and we will not use (pl/sql) in sql server but it was used in IBM DB2 .

DECLARE

     Variable declaration // here we declare variables 

BEGIN

     Program Execution  // here we do program execution 

EXCEPTION

     Exception handling // here we do exception handling

END;

Thanks and Regards
V.SaratChand
Show difficulties that how difficult you are

Rajeshk, if this helps please login to Mark As Answer. | Alert Moderator

Thank you very much sarat but it was like stored procedure na? can you differentiate

Thanks&Regards
rajeshkommireddy@gmail.com

Rajeshk, if this helps please login to Mark As Answer. | Alert Moderator

we can say that both are identical but pl/sql function will always return a value

Thanks and Regards
V.SaratChand
Show difficulties that how difficult you are

Rajeshk, if this helps please login to Mark As Answer. | Alert Moderator