以前有个mysql的项目 有个sql语句是这样的
INSERT INTO tb_polloption (pid, choice) VALUES ('6a378681e2d24f6c85cd5760722d3dbb', '11'),('6a378681e2d24f6c85cd5760722d3dbb', '2'),('6a378681e2d24f6c85cd5760722d3dbb', '3')
现在要用orcale 有哪位大侠知道怎么实现同样的功能呢~
INSERT INTO tb_polloption (pid, choice) VALUES ('6a378681e2d24f6c85cd5760722d3dbb', '11'),('6a378681e2d24f6c85cd5760722d3dbb', '2'),('6a378681e2d24f6c85cd5760722d3dbb', '3')
现在要用orcale 有哪位大侠知道怎么实现同样的功能呢~
解决方案 »
- 首次需要在AIX配置四个用户及其表空间,请诸位高手不吝赐教!
- 关于监听频繁死掉问题,oracle 9i widows 2003
- oracle 复杂报表统计显示
- ★★★★★★★ 天啊, 这就是 CSDN ? 太让我失望了! ★★★★★★★
- 在PLSQL Developer中用关联查询,找不到想要的资料,请高人帮忙看看
- oracle中有没有办法,把汉字转为拼音?
- Oracle10g使用DBCA创建数据库模板报“ORA-07445”
- 简单问题
- 在linux7.2下远程安装oracle9.2.0.1的问题
- 求教一个比较棘手的问题
- ora-01157 suse Linux 下安装的oracle11g,请问dbwr跟踪文件路径是多少啊
- 关于oracle数据抽取的问题
SELECT '6a378681e2d24f6c85cd5760722d3dbb' AS pid, '11' AS choice
UNION all
SELECT '6a378681e2d24f6c85cd5760722d3dbb', '2'
UNION ALL
SELECT '6a378681e2d24f6c85cd5760722d3dbb', '3'用union all select 試試
PreparedStatement ps = null;
ps = conn.prepareStatement(sql);
ps.setString(1,"");
ps.setString(2,"");
ps.addBatch();
ps.setString(1,"");
ps.setString(2,"");
ps.addBatch();
ps.executeBatch();
这是sql server,他本来的实现就是sql server的。Oracle:
insert into [tb]
select xx,xx from dual
union all
select xx,xx from dual
INSERT INTO tb_polloption (pid, choice)
select '6a378681e2d24f6c85cd5760722d3dbb', '11' from dual
union all
select '6a378681e2d24f6c85cd5760722d3dbb', '2' from dual
union all
select '6a378681e2d24f6c85cd5760722d3dbb', '3' from dual;
已写入 file afiedt.buf 1 begin
2 INSERT INTO tb_polloption (pid, choice) VALUES ('6a378681e2d24f6c85cd5760722d3dbb', '11');
3 INSERT INTO tb_polloption (pid, choice) VALUES ('6a378681e2d24f6c85cd5760722d3dbb', '2');
4 INSERT INTO tb_polloption (pid, choice) VALUES ('6a378681e2d24f6c85cd5760722d3dbb', '3');
5* end;SQL> /PL/SQL 过程已成功完成。