[長知識] Oracle SQL Manipulating Data (控制資料)

把如何控制資料的語法分做幾類

1. 新增 insert into

insert into departments(id, name, t_id, t_name) values (007, Ken, 100, King);

2. 修改 update

update employees set id=008 where t_name=100;