SQL> create table RequestInfo
2 (
3 RIId number not null,
4 RICustomer varchar2(100) not null,
5 RIAttn varchar2(100) not null,
6 RIRequestDate date )
7 /Table created.
可以啊?
2 (
3 RIId number not null,
4 RICustomer varchar2(100) not null,
5 RIAttn varchar2(100) not null,
6 RIRequestDate date )
7 /Table created.
可以啊?
每次insert调用一次sequencename.next
wfeng7907(无风) :用sequence
每次insert调用一次sequencename.next
-------------------------
有些不明白,能否详细点.比如我现在要Insert一条数据.
Insert into RequestInfo (RICustomer,RIAttn,RIVenderCode,RIVenderName,RIPONumber,RIRequestDate)
Values ('Awd,'fedd','623','Ytt','fsdfsf','2005-06-16')
但是因为我还有一个主键列RIID,所以插入时出现:
cannot insert Null into ('tedd','RequestInfo','RIID')
start with 1
increment by 1
nomaxvalueinsert into RequestInfo values(RIIdNO.nextval,'Awd,'fedd','2005-06-16')
/
start with 1
increment by 1
nomaxvalue;
Insert into RequestInfo
(RIID,RICustomer,RIAttn,RIVenderCode,RIVenderName,RIPONumber,RIRequestDate)
Values (RIIdNO.nextval,'Awd,'fedd','623','Ytt','fsdfsf','2005-06-16')
/
你再试试
hhb_100(暴风雪)
ORA-01756: 括号内的字符串没有正确结束。为什么?你将上面的语句放在哪里运行?