Questions about SQL and PL/SQL

Asked By kate sandler 330 points N/A Posted on - 10/21/2011

I am working on an Oracle database and I need information about SQL and PL/SQL. I heard many Oracle apps are based on PL/SQL. What are the difference between the two and do I need to use PL/SQL or Java to encode triggers and procedures?

• Status: Open
• Question Views: 1025
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Jude_maclane 0 points N/A #108661

Questions about SQL and PL/SQL

Greetings kate,

Yes you heard it right.  Many Oracle apps are based on PL/SQL as it is the one language which is mainly used for working along with Oracle databases. There are some differences in SQL and PL/SQL as follows:

• SQL is query language which is used for defining and manipulating data but PL SQL is a language which is used to create applications.
• SQL can only execute one statement at a given time but using PL SQL block of code can be executed.
• PL SQL is more like procedural language while SQL is declarative.
• With SQL, you can write queries , Data manipulation and data definition language(DML and DDL) while with PL SQL  you can write program,  function procedures and packages.

About Jude_maclane

Questions
0

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 10/22/2011
• Question Category: MySQL Server