简单的学习笔记

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) );