oracle创建id自增及相关增删改查操作
新建下载权限记录表 DOWNLOADPOPE_TAB字段：id、用户id、有下载权限的下载中心分类表id、有上传权限的下载中心分类表id ID（int）、userid（int）、downid（string）、upid（string） 执行语句 //1创建 CREATE TABLE DOWNLOADPOPE_TAB ( IDINT NOT NULL, USERIDINT NOT NULL, DOWNIDVARCHAR(60), UPID VARCHAR(60), CONSTRAINT DOWNLOADPOPE_TAB PRIMARY KEY (ID) ); //2创建自动增长序列 CREATE SEQUENCE DOWNLOADPOPE_TAB_Sequence INCREMENT BY 1 START WITH 1 NOMAXVALUE NOCYCLE CACHE 10; //3创建触发器 CREATE TRIGGER DOWNLOADPOPE_TAB BEFORE insert ONDOWNLOADPOPE_TAB FOR EACH ROW begin select DOWNLOADPOPE_TAB_Sequence.nextval into:New.id from dual; end; //4.提交 commit; //5.插入 INSERT INTO DOWNLOADPOPE_TAB(userid,downid,upid)VALUES(100123,'oracle sql','54.70'); //6.查询 select * from jxpost.DOWNLOADPOPE_TAB //7.删除数据 DELETE DOWNLOADPOPE_TAB where id=1 //8.删除表 DROP TABLEDOWNLOADPOPE_TAB
页:
[1]