Tips on cursor

1. The number of variables must be equal to the number of column or expression in the SELECT list.
2. The number of component in record must match the column or expression in the SELECT list.
3. The scope of cursor declared in the main block extends to the sub block.
4. PL/SQL variable , expression and SQL function can be included in the cursor SELECT List.
5. Alias name is required for calculated column when it is referenced in the program.