oracle之DML

插入语句

-- 插入语句
insert into stu (id,name,age,sex) values(seq_test.nextval,'李四',18,'男');
commit;

insert into stu values(seq_test.nextval,'王武',21,'男');
commit;

-- 插入另一个表中的数据，从另一个表中进行获取
insert into student select * from stu;
commit;

-- 创建表
create table stu_bak as select * from stu;
commit;

select * from stu_bak;

修改语句

insert into stu (id,name)values(seq_test.nextval,'测试序列');

-- 修改
update stu set name='赵六' where ID='6';
commit;

update stu set name='田七' where age='18';
commit;

update stu set age=age+1 where id='6';
commit;

删除语句

-- 删除语句
delete from stu where id='6';
commit;

-- 删除语句
delete stu where id='7';
commit;

-- 截断表
TRUNCATE TABLE stu;