Execute immediate不使用select into

DECLARE
    v_result NUMBER;
BEGIN
    EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM employees WHERE department_id = 10' INTO v_result;
    DBMS_OUTPUT.PUT_LINE('Number of employees in department 10: ' || v_result);
END;
/

DECLARE
    v_employee_id NUMBER := 100;
    v_first_name VARCHAR2(20) := 'John';
    v_last_name VARCHAR2(20) := 'Doe';
BEGIN
    EXECUTE IMMEDIATE 'INSERT INTO employees (employee_id, first_name, last_name) VALUES (:1, :2, :3)'
        USING v_employee_id, v_first_name, v_last_name;
    COMMIT;
END;
/

DECLARE
    v_table_name VARCHAR2(30) := 'temp_table';
BEGIN
    EXECUTE IMMEDIATE 'CREATE TABLE ' || v_table_name || ' (id NUMBER, name VARCHAR2(50))';
END;
/

DECLARE
    v_table_name VARCHAR2(30) := 'temp_table';
BEGIN
    -- 确保表已经存在
    EXECUTE IMMEDIATE 'CREATE TABLE ' || v_table_name || ' (id NUMBER, name VARCHAR2(50))';

    -- 现在可以安全地使用这个表名
    EXECUTE IMMEDIATE 'INSERT INTO ' || v_table_name || ' (id, name) VALUES (:1, :2)'
        USING 1, 'Alice';
    COMMIT;
END;
/