O'Reilly logo

Oracle SQL Revealed: Executing Business Logic in the Database Engine by Alex Reprintsev

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required