如何插入多条记录，

[y_cc]

比如说mysql是这样插入的

insert into user_group_tel(id,group_id,tel_number,record_time) values(msg_seq.nextval,54,'13700001234',sysdate),(msg_seq.nextval,54,'13700001231',sysdate),(msg_seq.nextval,54,'13700001232',sysdate),(msg_seq.nextval,54,'13700001233',sysdate),(msg_seq.nextval,54,'13700001234',sysdate)

[wgsasd311]

insert into user_group_tel(id,group_id,tel_number,record_time) values(msg_seq.nextval,54,'13700001234',sysdate);
insert into user_group_tel(id,group_id,tel_number,record_time) values(msg_seq.nextval,54,'13700001231',sysdate);
insert into user_group_tel(id,group_id,tel_number,record_time) values
(msg_seq.nextval,54,'13700001232',sysdate);
insert into user_group_tel(id,group_id,tel_number,record_time) values
(msg_seq.nextval,54,'13700001233',sysdate);
insert into user_group_tel(id,group_id,tel_number,record_time) values
(msg_seq.nextval,54,'13700001234',sysdate)
--or
insert into user_group_tel(id,group_id,tel_number,record_time)
select msg_seq.nextval,54,'13700001234',sysdate from dual
union all select msg_seq.nextval,54,'13700001231',sysdate from dual
union all select msg_seq.nextval,54,'13700001232',sysdate from dual
union all select msg_seq.nextval,54,'13700001233',sysdate from dual
union all select msg_seq.nextval,54,'13700001234',sysdate from dual;

[zhpsam109]

up!

[y_cc]

运行不了， 提示

select msg_seq.nextval,54,'13700001234',sysdate from dual
*
ERROR 位于第 2 行:
ORA-02287: 此处不允许序号

[bzszp]

逐行插入吧。

[xjqqxjqq]

看看是不是字段类型不对啊，

SQL> desc test_5
Name Type Nullable Default Comments
---- ----------- -------- ------- --------
NAME VARCHAR2(2) Y
XH NUMBER Y

SQL> insert into test_5 values('b',hy.nextval);

1 row inserted

[y_cc]

类型和字段是正确的，插入单条是成功的

[y_cc]

它提示不能使用msg_seq.nextval

[clican]

到PL/SQL command窗口里插试试看

[y_cc]

试过啦，全部不行……

[y_cc]

我还想问一下， 要是象这种的
insert into user_group_tel(id,group_id,tel_number,record_time) values(msg_seq.nextval,54,'13700001234',sysdate);
insert into user_group_tel(id,group_id,tel_number,record_time) values(msg_seq.nextval,54,'13700001231',sysdate);
insert into user_group_tel(id,group_id,tel_number,record_time) values
(msg_seq.nextval,54,'13700001232',sysdate);
insert into user_group_tel(id,group_id,tel_number,record_time) values
(msg_seq.nextval,54,'13700001233',sysdate);
insert into user_group_tel(id,group_id,tel_number,record_time) values
(msg_seq.nextval,54,'13700001234',sysdate)

怎么组合语句？一个长句，它提示我";"符号错误,要分行才行，
我用\n分行不行，这个怎么解决？

[Snoworld]

循环

[icefire1512]

批处理