- 创建一个表
create table student(
name varchar2(20),
age number(3)
);
- 插入新记录
insert into student values('Tom', 18);
insert into student values('张三', 20);
insert into student values('李四', 22);
insert into student values('王五', 26);
- 查询所有记录
select * from student;
- 查看表结构
desc student;
- 删除表
drop table student;
- 删除表中所有数据(保留表结构)
delete from student;
- 删除表中指定数据
delete from student where age=20;
- 提交
commit;