Object types are an ideal object-oriented modeling tool, which you can use to reduce the cost and time required to build complex applications.
Besides allowing you to create software components that are modular, maintainable, and reusable, object types allow different teams of programmers to develop software components concurrently.
For additional information about dynamic SQL, see Without PL/SQL, Oracle must process SQL statements one at a time.
Applications written in PL/SQL can run on any operating system and platform where the Oracle database runs.
With PL/SQL, you can write portable program libraries and reuse them in different environments.
For information on the use of static SQL with PL/SQL, see Chapter 6, "Performing SQL Operations from PL/SQL".
For information on the use of dynamic SQL, see Chapter 7, "Performing SQL Operations with Native Dynamic SQL".
This division of work reduces network traffic and improves response times.
Stored procedures are cached and shared among users, which lowers memory requirements and invocation overhead.Running a SQL query and processing the result set is as easy in PL/SQL as opening a text file and processing each line in popular scripting languages.Using PL/SQL to access metadata about database objects and handle database error conditions, you can write utility programs for database administration that are reliable and produce readable output about the success of each operation.As Figure 1-1 shows, you can use PL/SQL blocks and subprograms to group SQL statements before sending them to the database for execution.PL/SQL also has language features to further speed up SQL statements that are issued inside a loop.PL/SQL stored procedures are compiled once and stored in executable form, so procedure calls are efficient.