Expert
Q: | |
6-23. | The best way to scan the contents of an index-by table is shown in (d). Start with the first row in the table. If this returns NULL, the table is empty, and you stop immediately. Otherwise, display the present and then move on to the next defined row with the NEXT method. It is efficient, very readable, and doesn’t raise NO_DATA_FOUND errors. Now what is wrong with each of the other approaches?
|
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.