第二章 插入 修改 删除

/插入/
INSERT INTO bonus(ENAME,JOB,SAL,COMM)
VALUES (‘cici’,’CLECK’,10000,5000);
INSERT INTO bonus(ENAME,JOB,SAL,COMM)
VALUES (‘adith’,’SALEMAN’,5000,2000);
INSERT INTO bonus(ENAME,JOB,SAL,COMM)
VALUES (‘JOHN’,’CLECK’,7690,500);
INSERT INTO bonus(ENAME,JOB,SAL,COMM)
VALUES (‘xixi’,’CLECK’,9888,2987);
INSERT INTO bonus(JOB,SAL,COMM,ENAME)
VALUES (‘CLECK’,9888,2987,’jaent’);
INSERT INTO bonus
VALUES (‘coco’,’CLECK’,9888,2987);

/INFOS3/
INSERT INTO INFOS3
VALUES (‘林冲’,’男’,22,2,TO_DATE(‘2009-8-9 06:30:10’,’YYYY-MM-DD HH24:MI:SS’),’西安’,’1001’);

/通过结果集进行插入/
INSERT INTO INFOS2 SELECT * FROM INFOS3;

/修改/
UPDATE INFOS1
SET STUADDRESS=’云南’,AGE=56
where stuname = ‘林冲 ’

/删除/
delete from infos1 where stuname = ‘林冲 ’ ;

/全表删除/
TRUNCATE TABLE infos2 ;