DIFFERENCE BETWEEN SQL AND PL/SQLgreenspun.com : LUSENET : OpenKnowledge : One Thread
WHAT IS THE DIFFERENCE BETWEEN SQL AND PL/SQL?
-- Navneet Sahota (firstname.lastname@example.org), August 02, 2003
-- test (email@example.com), August 11, 2003.
please forward me the anser if u get . thanks
-- vru (firstname.lastname@example.org), October 15, 2003.
SQL Enter, Edit, Store & Retrieve by single command or statement where as PL/SQL process all SQL statements one at a time. With PL/SQL, an entire block of statements process in a single command line.
-- Tanveer (email@example.com), October 27, 2003.
sql is structured query language ,various queries are used to handle the database in a simplified manner. while pl/sql is procedural language contains various types of variable,functions and procedures,
-- laxmi shiwach (firstname.lastname@example.org), November 17, 2004.
SQL gives complete access to our data.I , mean ,we can get to everything...eventually...in less than ideal ways in many cases.There is no guarantee of efficiency. SQL Provides no ability to
1) Loop through records,manipulating them one at time 2) keep code secure by offering encryption, and sorting code permanently on the server rather than the client 3) Handle Exceptions. 4) Work with Variables,Parameters,Collections,Records,Arrays,Objects,Cursors, Exception,BFILES,etc.
-- Shravan kumar (email@example.com), December 01, 2004.
Sql as the name suggest it is just structured query language wheareas PLSQL is a commbination of Programming language & SQL.
-- Ajit Prasad (firstname.lastname@example.org), December 28, 2004.
PL/SQL is abbreviation of Procedural Language/Structured Query Language i.e. it is an entension to SQL from Oracle. Now, as the name suggests, Once you know what a procedural language can offer, you better understand what PL/SQL offers more than SQL (e.g. looping, variables)?
-- Pratik Patel (email@example.com), January 31, 2005.
SQL is Structured Query Language whereas PL/SQL is extension to SQL and we can use it to do programming at backend.
-- Shahaji M. Gole (firstname.lastname@example.org), February 14, 2005.
I've no answer for this.
-- Diwakar (email@example.com), February 22, 2005.
I've already told that I don't have any answer for this.
-- Divakar (firstname.lastname@example.org), February 22, 2005.