Discussion in 'SQL PL/SQL' started by monkey, Apr 19, 2014.
What is the difference between pl/sql and sqlit?
PL/SQL is a procedural language. It allows you to create programming logic such as loop and IF-THEN conditions. You can define and assign values to variables. You can execute SQL statements from inside PL/SQL and process the results.
SQL is strictly a language that allows you to query the database (SELECT), manipulate data (INSERT/UPDATE/DELETE/MERGE) or manipulate database objects (CREATE/ALTER). You cannot create a loop in SQL. You have very limited conditional logic capabilities (through DECODE and CASE). You cannot create variables.