PLSQL Language Reference-PL/SQL語言基礎-變數賦值-使用賦值語句賦值

變數名 := 表示式;

DECLARE 

    --可以在定義時指定初始值

    wages          NUMBER;

    hours_worked   NUMBER := 40;

    hourly_salary  NUMBER := 22.50;

    bonus          NUMBER := 150;

    country        VARCHAR2(128);

    counter        NUMBER := 0;

    done           BOOLEAN;

    valid_id       BOOLEAN;

    emp_rec1       employees%ROWTYPE;

    emp_rec2       employees%ROWTYPE;

    TYPE commissions IS TABLE OF NUMBER INDEX BY PLS_INTEGER;

    comm_tab       commissions;

BEGIN 

    --也可以在宣告之後賦值

    wages := (hours_worked * hourly_salary) + bonus;

    country := 'France';

    country := UPPER('Canada');

    done := (counter > 100);

    valid_id := TRUE;

    emp_rec1.first_name := 'Antonio';

    emp_rec1.last_name := 'Ortiz';

    emp_rec1 := emp_rec2;

    comm_tab(5) := 20000 * 0.15;

END;