What are the three advantages of cursors?
1. Coding in the procedure is greatly simplified.
2. In a normal PL/SQL program, the programmer must determine the most efficient way to access the data. In a program using embedded SQL, a special component of the database management system called the optimizer determines the best way to access the data.
3. If the database structure changes in such a way that the necessary information is still obtainable using a different query, the only change required in the program is the cursor definition. The procedural code is not affected.