Oracle学习笔记(一)
1. oracle基本语法
1.1 建表
CREATE TABLE TAB_XUE_STU
(
ID NUMBER(4),
NAME VARCHAR2(20),
AGE NUMBER(2),
SEX CHAR(2)
);
1.2 插入数据
INSERT INTO TAB_XUE_STU(ID, NAME, AGE, SEX)
VALUES(1, '李元芳', 18, '男');
COMMIT;
1.3 修改数据
UPDATE TAB_XUE_STU SET AGE = 20
WHERE 1 = 1 AND ID = 1;
COMMIT;
1.4 查询数据
SELECT * FROM TAB_XUE_STU T
1.5 在Oracle中实现自增ID
CREATE SEQUENCE SEQ_XUE_STU
INCREMENT BY 1 START WHIT 1
NOMAXVALUE NOCYCLE CACHE 20;
CREATE OR REPLACE TRIGGER TRG_XUE_STU
BEFORE INSERT ON TAB_XUE_STU
FOR EACH ROW
BEGIN
SELECT SEQ_XUE_STU.NEXTVAL INTO :NEW.ID FROM DUAL;
END;