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

posted @ 2018-10-27 15:46  小狗吃月亮  阅读(110)  评论(0编辑  收藏  举报