September 2002
Intermediate to advanced
1024 pages
30h 52m
English
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.
Read now
Unlock full access