PLSQL Language Referenc-PL/SQL静态SQL-静态SQL的描述-语句

-- PL/SQL静态SQL

DROP TABLE employees_temp;

CREATE TABLE employees_temp AS

    SELECT employee_id, first_name, last_name

    FROM employees;

DECLARE

    emp_id          employees_temp.employee_id%TYPE := 299;

    emp_first_name  employees_temp.first_name%TYPE  := 'Bob';

    emp_last_name   employees_temp.last_name%TYPE   := 'Henry';

BEGIN

    --静态SQL语句，INSERT, UPDATE, DELETE和COMMIT

    INSERT INTO employees_temp (employee_id, first_name, last_name)

    VALUES (emp_id, emp_first_name, emp_last_name);

    UPDATE employees_temp

    SET first_name = 'Robert'

    WHERE employee_id = emp_id;

    DELETE FROM employees_temp

    WHERE employee_id = emp_id

    RETURNING first_name, last_name

    INTO emp_first_name, emp_last_name;

    COMMIT;

    DBMS_OUTPUT.PUT_LINE (emp_first_name || ' ' || emp_last_name);

END;