And What Else?
We’ve seen how to use PL/SQL in SQL*Plus and in a number of other common environments and programming languages. There are still more places you can use PL/SQL:
Embedded in COBOL or FORTRAN and processed with Oracle’s precompiler
Called from Visual Basic, using some flavor of ODBC
Called from the Ada programming language, via a technology called SQL*Module
Executed automatically, as triggers on events in the Oracle database such as table updates
Scheduled to execute on a recurring basis inside the Oracle database, via the DBMS_JOB built-in package
We’ll take a look at some of these approaches in upcoming chapters.
Get Oracle PL/SQL Programming, Third Edition 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.