Skip to Main Content
Oracle PL/SQL Programming: A Developer's Workbook
book

Oracle PL/SQL Programming: A Developer's Workbook

by Steven Feuerstein, Andrew Odewahn
May 2000
Intermediate to advanced content levelIntermediate to advanced
594 pages
11h 32m
English
O'Reilly Media, Inc.
Content preview from Oracle PL/SQL Programming: A Developer's Workbook

Expert

29-28.

Match the following V$ views to their proper description:

View:

  1. V$ROWCACHE

  2. V$LIBRARYCACHE

  3. V$SQLAREA

  4. V$DB_OBJECT_CACHE

Description:

  1. Contains the number of times an element has been loaded into the SGA, its number of executions, whether it has been pinned, and whether it has been referenced but not loaded

  2. Contains object access cache “hits and misses”

  3. Contains statistics on the shared SQL area, one row per string

  4. Contains data dictionary cache “hits and misses”

29-29.

The following program creates an index-by table holding a schedule of lease payments. The payment for each year is calculated as the sum of lease amounts for the remaining years. In other words, the total lease for year 10 consists of the lease amounts (fixed and variable) for years 10 through 20. Assuming that the functions pv_of_fixed and pv_of_variable are defined elsewhere, can you improve the program?

 /* Filename on web page: presvalue.sp */ /* Construct present value lease schedule over 20 years. */ PROCEDURE build_lease_schedule IS /* Temporary variable to hold lease accumulation. */ pv_total_lease NUMBER (9); BEGIN fixed_count := 0; var_count := 0; FOR year_count IN 1 .. 20 LOOP /* Reset the lease amount for this year. */ pv_total_lease := 0; /* || Build the PV based on the remaining years || plus the fixed and variable amounts. */ FOR year_count2 IN year_count .. 20 LOOP /* Add annual total lease amount to cummulative. ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Database 12c PL/SQL Programming

Oracle Database 12c PL/SQL Programming

Michael McLaughlin
Oracle PL/SQL for DBAs

Oracle PL/SQL for DBAs

Arup Nanda, Steven Feuerstein
Oracle PL/SQL For Dummies

Oracle PL/SQL For Dummies

Michael Rosenblum, Paul Dorsey

Publisher Resources

ISBN: 9781449324070Supplemental ContentErrata Page