What is the difference between SQL and PL/SQL?

Started by Sufyaan, April 07, 2016, 08:29:07 AM

Previous topic - Next topic

Bradley

Hi, I'd like to ask you a problem, I hope you can help me, what is the difference between sql and pl/sql? Thank you please kindly answer me !!! Cordially.

Patrick

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 "Procedural Language" 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.