Geek Answers Handbook

Oracle SQL vs Oracle PL / SQL

I need to learn Oracle SQL to work, and I was really tempted by O'Reilly's book, Oracle PL / SQL Programming, as it has been so revised. However, I do not quite understand if PL / SQL is another language for SQL, or if it is just a supernet or something else. Can someone please help me here? Thank you

+6
source share
2 answers

SQL is a data query and langauge manipulation. PL / SQL is a procedural programming language.

PL / SQL is the complete Turing language, with syntax for creating complex programs. It also has a large number of libraries that give it a wide range of capabilities. However, its primary use is undoubtedly the creation of stored procedures that include SQL statements for retrieving and manipulating data. Thus, PL / SQL is a superset of SQL.

Although in earlier versions of the database, the PL / SQL SQL engine lagged behind the database engine, so some SQL functions were not available in PL / SQL. Since 9i Oracle has gone crazy to keep both in step, and it’s quite difficult to find something that we can do in pure SQL, which we also cannot do in PL / SQL.

+12
source

it is a superset.

all SQL plus some PROCEDURAL extensions, so you can have variables, loops, conditional logic, etc.

+5
source

More articles:


All Articles