DML Data Manipulation Language exercises

--Create TABLE t_hq_bm2--CREATE TABLE t_hq_bm2 as SELECT * from T_HQ_BM;Commit;--Add line contents--INSERT into T_HQ_BM2 values (' 107 ', ' Research department ', ' 147258369 ');Commit;--delete line with department code 107--Delete t_hq_bm2 where bumenbm = ' 107 ';Commit;--Add line contents--INSERT INTO T_HQ_BM2 (Bumenbm,lianxidh) VALUES (' 107 ', ' 147258369 ');Commit; update all contact numbers for 123456789UpdateT_hq_bm2SetLianxidh= '123456789';Commit;--Update the department Code of 106 contact number for 147258369UpdateT_hq_bm2SetLianxidh= '147258369' whereBumenbm= '106';Commit;--delete table contentsDeletet_hq_bm2;Commit;

DML Data Manipulation Language exercises