Oracle数据操纵语言

–添加数据 Insert into
指定字段名插入到指定字段，如果不指定，默认插入所有字段
insert into student
values(1,’lizq’,30);

insert into student(stu_id,stu_name)
values(2,’lee’);

insert into student
values(1,’lizq’,30,sysdate);

insert into student
values(1,’lizq’,30,to_date(‘23-12-2017 12:21:05’,’DD-MM-YYYY HH24:MI:SS’));

–插入多行数据
–把60号部门的员工信息（id，first_name）插入到student
insert into student(stu_id,stu_name,creat_time)
select e.employee_id,e.first_name,
from employees e
where e.department_id=60;

–修改语句 Update
update student
set stu_age=19,stu_name=’lalala’,creat_time=’22-12月-12’
where stu_id=2

–删除语句 Delete
delete from student
where stu_id=104;
select *
from student;
rollback;
select *
from student;