Expert
29-28. | Match the following V$ views to their proper description: View:
Description:
|
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. ... |
Get Oracle PL/SQL Programming: A Developer's Workbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.