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
版权声明:本文为jinlin-2018原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。