分类: Oracle
2008-05-23 13:17:45
来源: |
|
--创建表 CREATE TABLE "TEST" ( "id" number(4) NOT NULL, "name" varchar2(30)); --创建递增对象,且它的初始值为1,增量也为1 create sequence squ_AutoId increment by 1 start with 1; --添加数据 insert into TEST(id, name) values(squ_AutoId.nextval, 'name'); |