修改:DDL语言
添加列:alter table 表名 add column type;
alter table student add tel varchar2(11);
修改列:
alter table student modify tel number(11,0);
删除列:
alter table student drop column tel;
修改列名:
alter table student rename column sex to gender;
修改表名:
rename student to studedntinfo;
删除:
Truncate:删除表中的全部数据,速度比delete快
truncate table emp_bak;
Drop:删除表结构
drop table emp_bak;
INSERT :
insert into student(sid,name,gender) values(1,'sisi','女');
insert into student(sid,name,gender,address, birthday) values(1,'sisi','女','北京',to_date('19950723','YYYYMMDD'));
insert into student values(1,'sisi','女',TO_DATE('19950909','YYYYMMDD'),'武汉','技术部');
SELECT:
自练
UPDATE:
update student set address ='武汉' where sid='1';
更新所有字段:
update student set address='武汉';
DELETE:
delete form student where sid='01';
删除所有数据:
delete from student;