Abstract
One of the beauties of the SQL language in Oracle is that it can so easily be extended by writing functions that SQL can call. But the thing to note is that SQL and PL/SQL are executed by two different engines, each with small differences, for example, how variables, datatypes, and memory are handled. Every time SQL calls a PL/SQL function, or vice versa PL/SQL executes static or dynamic SQL, data is passed from one engine to the other with some possible conversion along the way – this is called a context switch. In version 12.1, it became possible to minimize this context switch, so it often becomes barely noticeable.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2020 Kim Berg Hansen
About this chapter
Cite this chapter
Berg Hansen, K. (2020). Functions Defined Within SQL. In: Practical Oracle SQL. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5617-6_5
Download citation
DOI: https://doi.org/10.1007/978-1-4842-5617-6_5
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-5616-9
Online ISBN: 978-1-4842-5617-6
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books