--插入信息 INSERT INTO * () VALUES(*,*,*)
INSERT INTO STUDENT(ST_ID,ST_NAME,ST_SEX,ST_HOBBY,ST_JOIN_DATA) VALUES(1,'TOM','男','音乐','26-9月-18')
--修改日期格式 ALTER SESSION SET NLS_DATA_FORMAT=*
ALTER SESSION SET NLS_DATA_FORMAT='YYYY-MM-DD HH24:MI:SS'
--修改表的字段 UPDATE * SET * = * WHERE * = *
UPDATE TABLE STUDENT SET ST_HOBBT ='游戏' WHERE ST_ID=3
--字符串拼接 ||
UPDATE STUDENT SET ST_HOBBT =ST_HOBBIES||',游戏' WHERE ST_ID=3
--为不为空 IS NULL
UPDATE STUDENT SET ST_NAME='TOM' WHERE ST_HOBBY IS NULL
--删除数据 DELETE FROM * WHERE *=*
DELETE FROM STUDENT WHERE ST_ID=3