oracle 数据库出问题?
我建好表以后插入数据,但是主键显示都是0,请问怎么处理???
[最优解释]
1)
u1@EMREP> create table dept(dept_id number(6) primary key,dept_name varchar2(20) not null);
Table created.
u1@EMREP> insert into dept values(0,'IT');
1 row created.
u1@EMREP> insert into dept values(1,'FINACIAL');
1 row created.
u1@EMREP> commit;
Commit complete.
u1@EMREP> select * from dept;
DEPT_ID DEPT_NAME
---------- --------------------
0 IT
1 FINACIAL