如何插入多条记录，

Question

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;

Answer 1

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

Answer 2

看看是不是字段类型不对啊，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

Answer 3

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

Answer 4

我还想问一下， 要是象这种的
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分行不行，这个怎么解决？