Database Programming with PL/SQL
1-2: Benefits of PL/SQL
Practice Activities
Vocabulary
The ability for PL/SQL programs to run anywhere an Oracle server runs. - Portability
The basic unit of PL/SQL programs- also known as modules. - Blocks
An error that occurs in the database or in a user’s program during runtime. - Exceptions
Try It / Solve It
1. Why is it more efficient to combine SQL statements into PL/SQL blocks
An application is more efficient when created in PL/SQL blocks; there is less
network traffic, resulting in a faster application.
2. Why is it beneficial to use PL/SQL with an Oracle database? List at least three reasons.
Integration of procedural constructs with SQL.
Improve Performance.
Exception handling.
3. How is PL/SQL different from C and Java? List three differences.
PL/SQL requires a database or Oracle tool.
PL/SQL allows for some object-oriented programming techniques, but is not as
extensive as Java.
PL/SQL is the most efficient language to use with an Oracle database.
0 Comments