| Q1: |
Can a stored procedure call another stored procedure? |
|
A1:
| Yes. The stored procedure being called is referred to as being nested. |
| Q2: |
How do I execute a cursor? |
|
A2:
| Simply use the OPEN CURSOR statement. This sends the results of the cursor to a staging area. |