Oracle增刪改DML指令碼記錄

標籤：

--insert into添加資料insert into student(sno,sname,ssex) values(‘110‘,‘王軍‘,‘男‘);--提交事物commit;--復原事物--rollback;insert into teacher1 select * from teacher;insert into teacher1(ton,tname,prof) select ton,tname,prof from teacher;--選擇性插入兩表之間insert into teacher1 t(ton,tname,prof) select ton,tname,prof from teacher where ton=‘804‘;--修改 updateupdate student set sclass=‘95031‘，ssex=‘女‘ where son=‘104‘;commit--修改成績update score set degree=degree+1;--將空sclass內容更改95033update student set sclass=‘95033‘ where sclass is null; --刪除 deletedelete from student where sno=‘104‘;--全錶快速清空：先刪表，在建表truncate table stdent;

 

Oracle增刪改DML指令碼記錄