Intermediate
29-13. | What is the most efficient integer datatype for numbers in the 231 range?
|
29-14. | Explain why Snippet (a) is superior to Snippet (b):
|
29-15. | Explain why Trigger (a) is better than Trigger (b):
|
29-16. | Improve the performance of the following code (assume that process_employee_history has been optimized): DECLARE CURSOR emp_cur IS SELECT last_name, TO_CHAR (SYSDATE, 'MM/DD/YYYY') today FROM employee; BEGIN FOR rec IN emp_cur LOOP IF LENGTH (rec.last_name) > 20 THEN rec.last_name := SUBSTR (rec.last_name, 20); END IF; process_employee_history ... |
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.