在Oracle/Generate insert语句中使用不同的值(SQL)将测试数据插入到表中的快速方法是什么？

INSERT INTO employees (employee_id, first_name, last_name, email, hire_date)
VALUES (1, 'John', 'Doe', 'john.doe@example.com', TO_DATE('2023-01-01', 'YYYY-MM-DD'));

INSERT INTO employees (employee_id, first_name, last_name, email, hire_date)
VALUES (2, 'Jane', 'Smith', 'jane.smith@example.com', TO_DATE('2023-02-01', 'YYYY-MM-DD'));

INSERT ALL
INTO employees (employee_id, first_name, last_name, email, hire_date)
VALUES (1, 'John', 'Doe', 'john.doe@example.com', TO_DATE('2023-01-01', 'YYYY-MM-DD'))
INTO employees (employee_id, first_name, last_name, email, hire_date)
VALUES (2, 'Jane', 'Smith', 'jane.smith@example.com', TO_DATE('2023-02-01', 'YYYY-MM-DD'))
SELECT * FROM dual;

CREATE SEQUENCE employee_seq START WITH 1 INCREMENT BY 1;

INSERT INTO employees (employee_id, first_name, last_name, email, hire_date)
VALUES (employee_seq.NEXTVAL, 'John', 'Doe', 'john.doe@example.com', TO_DATE('2023-01-01', 'YYYY-MM-DD'));

INSERT INTO employees (employee_id, first_name, last_name, email, hire_date)
VALUES (employee_seq.NEXTVAL, 'Jane', 'Smith', 'jane.smith@example.com', TO_DATE('2023-02-01', 'YYYY-MM-DD'));

DECLARE
  TYPE t_employee IS TABLE OF employees%ROWTYPE;
  v_employees t_employee := t_employee();
BEGIN
  v_employees.EXTEND;
  v_employees(v_employees.COUNT).employee_id := 1;
  v_employees(v_employees.COUNT).first_name := 'John';
  v_employees(v_employees.COUNT).last_name := 'Doe';
  v_employees(v_employees.COUNT).email := 'john.doe@example.com';
  v_employees(v_employees.COUNT).hire_date := TO_DATE('2023-01-01', 'YYYY-MM-DD');

  v_employees.EXTEND;
  v_employees(v_employees.COUNT).employee_id := 2;
  v_employees(v_employees.COUNT).first_name := 'Jane';
  v_employees(v_employees.COUNT).last_name := 'Smith';
  v_employees(v_employees.COUNT).email := 'jane.smith@example.com';
  v_employees(v_employees.COUNT).hire_date := TO_DATE('2023-02-01', 'YYYY-MM-DD');

  FORALL i IN 1..v_employees.COUNT
    INSERT INTO employees VALUES v_employees(i);
END;
/