简单的学习笔记

SELECT 语句：SELECT ID FROM STU;UPDATE语句：UPDATE STU SET ID=1 WHERE NAME = 'SSUN';DELETE语句：DELETE FROM STU WHERE ID=1;INSERT语句：INSERT INTO STU (ID,NAME) VALUES(2,'SSUN125');删除表：DROP TABLE STU;新建表(加主键和外键)：CREATE TABLE STU (ID NUMBER(10) PRIMARY KEY,NAME VARCHAR2(20),CLASSID NUMBER(10) REFERENCES CLASS(ID));