1、创建一张测试表 TEST_DEMO
CREATE TABLE TEST_DEMO
(
ID VARCHAR2(20) NOT NULL PRIMARY KEY,
CODE VARCHAR2(20) ,
NAME VARCHAR(20),
ADDRESS VARCHAR2(20)
)
2、创建序列,作为主键值
CREATE SEQUENCE SEQ_TEST_DEMO_ID
INCREMENT BY 1
START WITH 1
NOMAXvalue
NOCYCLE
NOCACHE;
3、插入测试数据 insert
insert into TEST_DEMO values (SEQ_TEST_DEMO_ID.NEXTVAL,'0001','测试用户1','测试1');
insert into TEST_DEMO values (SEQ_TEST_DEMO_ID.NEXTVAL,'0002','测试用户2','测试2');
insert into TEST_DEMO values (SEQ_TEST_DEMO_ID.NEXTVAL,'0003','测试用户3','测试3');
insert into TEST_DEMO values (SEQ_TEST_DEMO_ID.NEXTVAL,'0004','测试用户4','测试4');
insert into TEST_DEMO values (SEQ_TEST_DEMO_ID.NEXTVAL,'0005','测试用户5','测试5');
4、查询数据 select
SELECT * FROM TEST_DEMO
5、更改数据 update
UPDATE TEST_DEMO SET CODE = '6666' WHERE CODE = '0001'
6、删除数据 delete
DELETE FROM TEST_DEMO WHERE CODE = ''
以上为基本增删改查数据sql操作