Oracle批量插入
INSERT INTO t_role(rid,rname)
SELECT 1,'管理员' FROM dual
UNION
SELECT 2,'系统用户' FROM dual
UNION
SELECT 3,'货代' FROM dual
UNION
SELECT 4,'供应商' FROM dual
UNION
SELECT 5,'客户' FROM dual
INSERT INTO t_role(rid,rname)
SELECT 1,'管理员' FROM dual
UNION
SELECT 2,'系统用户' FROM dual
UNION
SELECT 3,'货代' FROM dual
UNION
SELECT 4,'供应商' FROM dual
UNION
SELECT 5,'客户' FROM dual