Question

在oracle sql developer怎么创建主键自增

不是用代码实现

Answer 1

Oracle 没有自增的概念，需要用触发器加sequence来实现

ORACLE SEQUENCE 介绍
http://blog.csdn.net/tianlesoftware/archive/2009/10/30/4745039.aspx

Answer 2

Create table jjfa_infor(
id number primary key,
companyname varchar2(100)
)
tablespace hzhb
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);

CREATE SEQUENCE s_jjfa_infor start with 1 increment by 1;
用序列实现