Transfer of control statements are used to redirect the flow of control within an SQL procedure.
Transfer of control statements can be used anywhere within an SQL procedure, however ITERATE and LEAVE are generally used in conjunction with a LOOP statement or other looping statements.