Oracle SQL Revealed: Executing Business Logic in the Database Engine

© Alex Reprintsev 2018

Alex ReprintsevOracle SQL Revealedhttps://doi.org/10.1007/978-1-4842-3372-6_11

11. When PL/SQL Is Better Than Vanilla SQL

Alex Reprintsev¹ 

(1)

London, UK

 

It was already mentioned a few times that for many tasks, instead of using advanced Oracle features like a model clause or recursive subquery factoring, you can implement the logic in PL/SQL with better performance and scalability . However PL/SQL may be a better choice to get a recordset even if the challenge can be addressed with basic SQL features only. As a rule, the reason is because of limitations or current implementation of SQL or specifics of SQL queries. SQL is declarative language and its implementation in Oracle RDBMS is not open source; thus what is happening ...