PLSQL Language Referenc-PL/SQL集合和記錄-使用記錄更新行

--使用記錄更新行

DECLARE

    default_week  schedule%ROWTYPE;

BEGIN

    default_week.Mon := 'Day Off';

    default_week.Tue := '0900-1800';

    default_week.Wed := '0900-1800';

    default_week.Thu := '0900-1800';

    default_week.Fri := '0900-1800';

    default_week.Sat := '0900-1800';

    default_week.Sun := 'Day Off';

    FOR i IN 1..3 LOOP

        default_week.week := i; 

        UPDATE schedule

        SET ROW = default_week –更新整行

        WHERE week = i;

    END LOOP;

END;

--檢視結果