Describe at least four advantages of using PL/SQL.
What will be an ideal response?
Tight integration with SQL-You can leverage your knowledge of SQL because PL/SQL supports the use of SQL data manipulation, transaction control, functions, cursors, operators, and pseudocolumns. In addition, PL/SQL fully supports SQL data types, which reduces the need to convert data passed between your applications and the database.
Increased performance-First, PL/SQL allows blocks of statements to be sent to Oracle in a single transmission. This is important in reducing network communication between your application and Oracle, especially if your application is database intensive. PL/SQL blocks can be used to group SQL statements before sending them to Oracle for execution. Otherwise, each SQL statement must be transmitted individually. Second, PL/SQL code modules, or stored program units, are stored in executable form-making procedure calls very efficient. Third, executable code is automatically cached in memory and shared among users. This can speed processing tremendously with a multiuser application that has repeated calls to modules of code. Fourth, a PL/SQL engine is embedded in Oracle developer tools so that PL/SQL code can be processed on the client machine. This reduces network traffic.
Increased productivity-PL/SQL can be used in many of the Oracle tools, and the coding is the same within all. Therefore, your PL/SQL knowledge can be used with many development tools, and the code created can be shared across applications. Because a PL/SQL engine is part of the server, these code modules can also be used or called from almost any application development language. You can use Visual Basic or Java to develop an application but still harness the power of PL/SQL with Oracle.
Portability-PL/SQL can run on any platform that Oracle can run. This is important to enable a developer to easily deploy an application on different platforms.
Tighter security-Database security can be increased with application processing supported by PL/SQL stored program units. Program units can enable the access of database objects to users without the users being granted privileges to access the specific objects. Therefore, the users can access these objects only via the PL/SQL program units.
You might also like to view...
Under the Brussels Convention, which of the following claims has the highest rank?
A. Judicial costs and other expenses B. Salvage and general average C. Tort claims D. Ship mortgages
________ fairness, and legal compliance are the 3 consequences of an internally aligned pay structure.
A. Culture B. Organization factors C. Economic pressures D. Efficiency E. Human capital
?The mixed-standard scale method evaluates traits according to a single scale.
Answer the following statement true (T) or false (F)
______ is the range of values of the objective function within which the optimal values of the decision variables will not change.
a. Range of feasibility b. Range of optimality c. Range of redundancy d. Range of continuity