03_13.sql - DECLARE rec_project dd_project%ROWTYPE lv_prevGoal_num dd_project.projfundgoal%TYPE lv_newgoal_num dd_project.projfundgoal%TYPE:= 20000

03_13.sql - DECLARE rec_project dd_project%ROWTYPE...

This preview shows page 1 out of 1 page.

DECLARE rec_project dd_project%ROWTYPE; lv_prevGoal_num dd_project.projfundgoal%TYPE; lv_newgoal_num dd_project.projfundgoal%TYPE := 20000; lv_proj_num dd_project.idProj%TYPE := 500; BEGIN SELECT projfundgoal INTO lv_prevGoal_num FROM dd_project WHERE idProj = lv_proj_num; UPDATE dd_project SET projfundgoal = lv_newgoal_num WHERE idProj = lv_proj_num RETURNING idProj, projname, projstartdate, projenddate, projfundgoal, projcoord INTO rec_project; DBMS_OUTPUT.PUT_LINE('Name: ' || rec_project.projname); DBMS_OUTPUT.PUT_LINE('Start: ' || rec_project.projstartdate); DBMS_OUTPUT.PUT_LINE('Prev Goal: ' || lv_prevGoal_num); DBMS_OUTPUT.PUT_LINE('New Goal: ' || rec_project.projfundgoal); END;

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture