e.g.
SET SERVEROUTPUT ON
BEGIN
FOR trip_record IN (SELECT bt_id_pk, bt_duration
FROM business_trips) LOOP
-- implicit open/fetch occurs
IF trip_record.bt_duration = 1 THEN
DBMS_OUTPUT_LINE ('trip Number ' || trip_record.bt_id_pk
|| ' is a one day trip');
END IF;
END LOOP; -- implicit CLOSE occurs
END;
/
SET SERVEROUTPUT ON
BEGIN
FOR trip_record IN (SELECT bt_id_pk, bt_duration
FROM business_trips) LOOP
-- implicit open/fetch occurs
IF trip_record.bt_duration = 1 THEN
DBMS_OUTPUT_LINE ('trip Number ' || trip_record.bt_id_pk
|| ' is a one day trip');
END IF;
END LOOP; -- implicit CLOSE occurs
END;
/
No comments:
Post a Comment