| Oracle® PL/SQL® Interactive Workbook, Second Edition
By
Benjamin Rosenzweig, Elena Silvestrova
| | Table of Contents | |
Appendix A.
Answers to Self-Review Questions |
Chapter 9 Introduction to Cursors
Lab 9.1 Self-Review Answers | | A1:
| | | | A2:
| |
2) |
None |
Cursor attributes are used for getting information about cursors. They cannot be used to control or close cursors. |
| | | A3:
| |
3) |
1-B Declare, 2-E Open, 3-A Fetch, 4-C Close | |
| | | A4:
| |
4) |
D |
Cursor attributes can be use with both implicit and explicit cursors. |
| | | A5:
| |
Lab 9.2 Self-Review Answers | | A1:
| | | | A2:
| | | | A3:
| | | | A4:
| |
4) |
B |
A child cursor in a nested cursor loop will open, loop, and then close for each iteration of the parent loop. |
| | | A5:
| |
Lab 9.3 Self-Review Answers
|
1) |
A | |
2) |
A, B, E | |
3) |
C | |
4) |
C | |
5) |
A |
A WHERE CURRENT clause in a FOR UPDATE cursor allows you to update a row without having to match the row in the WHERE clause. |
|
|
| |
No comments:
Post a Comment