创建表
create table tb_user(
user_name varchar2(40) not null,
user_sex varchar2(10) not null,
user_age Integer not null,
user_job varchar2(40) not null
)
插入表数据
insert into tb_user values('小王','男',14,'学生');
insert into tb_user values('小红','女',15,'学生');
insert into tb_user values('小绿','男',16,'学生');
insert into tb_user values('小黑','男',24,'老师');
insert into tb_user values('老王','男',34,'老师');
insert into tb_user values('老刘','男',44,'老师');
insert into tb_user values('老路','男',54,'老师');
insert into tb_user values('生说','男',14,'学生');
insert into tb_user values('是红','女',15,'学生');
insert into tb_user values('王五','女',16,'学生');
insert into tb_user values('密码','女',24,'老师');
insert into tb_user values('老王','女',34,'老师');
insert into tb_user values('窃取','女',44,'老师');
insert into tb_user values('王五','女',54,'老师');
删除表数据
delete from tb_user where user_name = '小王';
修改表中数据
update tb_user set user_job = '人民大会堂' where user_name = '小红';
增加一列
alter table tb_user add(intruction varchar2(100);
ALTER TABLE tb_user ADD(photo VARCHAR(100) DEFAULT 'nophoto.jpg')//注 :图片插入
删除一列
alter table tb_user drop column photo;
修改一列
alter table tb_user modify ntruction varchar2(20);
增加多列:
alter table tb_user add (test varchar2(10),test2 number);
修改多列:
alter table tb_user modify (test varchar2(20),test2 varchar2(20));
删除多列:
alter table tb_user drop (test,test2);