WHERE rownum < 2;
DBMS_OUTPUT.PUT_LINE(‘City: ‘ || vr_zip.city);
DBMS_OUTPUT.PUT_LINE(‘State: ‘ || vr_zip.state);
DBMS_OUTPUT.PUT_LINE(‘ZIP: ‘ || vr_zip.zip);
CURSOR c_student_name IS
SELECT first_name, last_name
Record vr_student_name has a structure similar to a row returned by the SELECT statement defined in the cursor. It contains two attributes—the student’s first and last names. It is important to note that a cursor-based record can be declared only after its corresponding cursor has been declared; otherwise, a compilation error will occur.