Saved Bookmarks
| 1. |
Explain the "paradigm mismatch" between SQL and application programming languages. |
|
Answer» SQL statements return a set of rows, while an application program works on one row at a time. To resolve this mismatch the results of SQL statements are processed as pseudofiles, using a cursor or pointer to specify which row is being processed. |
|