Summary
PL/SQL is an extremely useful database programming language, which you can use to develop robust applications as well as run maintenance tasks and monitor databases. This chapter presented examples of how to use PL/SQL to build packages, procedures, functions, and triggers. We looked at some of the ways to process data through cursors, the syntax for updates, and other differences between the database programming languages. As you can see, there is plenty of fun to have with PL/SQL!
The processing of statements is similar in both platforms, requiring transaction and points to commit or rollback. Oracle packages allow procedures and functions to be grouped together. Packages can be used for several of the transactions and processes that ...
Get Oracle Database Administration for Microsoft SQL Server DBAs now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
