处理异常情态.PPTVIP

Bordoloi and Bock EXPLICIT CURSOR The only means of generating an explicit cursor is for the cursor to be named in the DECLARE section of the PL/SQL Block. The advantages of declaring an explicit cursor over the indirect implicit cursor are that the explicit cursor gives more programmatic control to the programmer. Implicit cursors are less efficient than explicit cursors and thus it is harder to trap data errors. Bordoloi and Bock EXPLICIT CURSOR The process of working with an explicit cursor consists of the following steps: DECLARING the cursor. This initializes the cursor into memory. OPEN