What actions can be performed on an explicit cursor? Give an example of each statement’s use.

What will be an ideal response?


Declare – CURSOR department_cursor IS SELECT * FROM dept;
Open – OPEN department_cursor;
Fetch data – FETCH department_cursor INTO dept_rec;
Close – CLOSE department_cursor;

Computer Science & Information Technology

You might also like to view...

By default, the duration of the setOpacity method is one second.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

PyOpenGL method_______ moves the camera away from the scene.

a) move_camera. b) set_camera. c) set_eyepoint. d) None of the above.

Computer Science & Information Technology

Every function includes a ____________________, which identifies it.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

Microsoft Office documents use the .odt extension

Indicate whether the statement is true or false

Computer Science & Information Technology