1,首先创建一张表
DROP TABLE EMPLOYEE;
CREATE TABLE EMPLOYEE
( FIRST_NAME VARCHAR2(20 BYTE),
LAST_NAME VARCHAR2(20 BYTE),
EMP_NO NUMBER,
JOIN_DATE DATE
)
TABLESPACE SYSTEM ;</span>
2,自定义一个行类型
create or replace
TYPE t_type AS OBJECT (
first_name varchar2(20),
last_name varchar2(20),
emp_no number,
join_date date
);
create or replace
type tb_t_type
as varray (1000000) of t_type;
4,最后我们再写一个批量插入的存储过程;
create or replace
procedure add_employees (emparray in tb_t