PLSQL Language Referenc-PL/SQL集合和記錄-記錄比較-將記錄插入到表中

DROP TABLE schedule;

CREATE TABLE schedule (

    week  NUMBER,

    Mon   VARCHAR2(10),

    Tue   VARCHAR2(10),

    Wed   VARCHAR2(10),

    Thu   VARCHAR2(10),

    Fri   VARCHAR2(10),

    Sat   VARCHAR2(10),

    Sun   VARCHAR2(10)

);

DECLARE

    default_week  schedule%ROWTYPE;

    i NUMBER;

BEGIN

    default_week.Mon := '0800-1700';

    default_week.Tue := '0800-1700';

    default_week.Wed := '0800-1700';

    default_week.Thu := '0800-1700';

    default_week.Fri := '0800-1700';

    default_week.Sat := 'Day Off';

    default_week.Sun := 'Day Off';

    FOR i IN 1..6 LOOP

        default_week.week := i; 

        --將記錄變數插入表中

        INSERT INTO schedule VALUES default_week;

    END LOOP;

END;

--檢視插入的記錄

select * from schedule;