Abstract
Real-life tasks that can be solved using Oracle SQL are covered in Part II of this book. PL/SQL solutions are also provided to highlight the limitations of SQL or to demonstrate that PL/SQL may be a preferred solution from a performance point of view even if the SQL solution looks concise and easy. Some real cases are presented as better than vanilla SQL.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsAuthor information
Authors and Affiliations
Rights and permissions
Copyright information
© 2018 Alex Reprintsev
About this chapter
Cite this chapter
Reprintsev, A. (2018). When PL/SQL Is Better Than Vanilla SQL. In: Oracle SQL Revealed. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-3372-6_11
Download citation
DOI: https://doi.org/10.1007/978-1-4842-3372-6_11
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-3371-9
Online ISBN: 978-1-4842-3372-6
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books