oracle 基本用法(软件pl/sql)

1.–基础用法

• 列表内容

–创建表
create table student(
stuid number(10),
stuname varchar2(20),
stuclass varchar2(20),
stuscore number(10)
)
–查看学习表
select * from student;
–插入内容
insert into student(stuid,stuname,stuclass,stuscore)
values(1001,’张三’,’大一’,90);
insert into student(stuid,stuname,stuclass,stuscore)
values(1002,’张四’,’大二’,95);
insert into student(stuid,stuname,stuclass,stuscore)
values(1003,’张五’,’大三’,70);
insert into student(stuid,stuname,stuclass,stuscore)
values(1004,’李三’,’大四’,60);
insert into student(stuid,stuname,stuclass,stuscore)
values(1005,’张四’,’大一’,93);
insert into student(stuid,stuname,stuclass,stuscore)
values(1006,’张四’,’大一’,93);
–修改数据
update student
set stuname=’小埋’
where stuid=1005;
–删除数据
delete from student
where stuid=1006;
–查询数据
select stuid,stuname
from student
where stuscore>90;
–链接多条件
select *
from student
where stuscore>90 or stuid>1002;
–范围条件筛选
select *
from student
where stuscore>=90 and stuscore<=95;
–为表添加一个字段
alter table student add sex varchar2(10);
–查看学习表
select * from student;
–修改字段
alter table student modify sex varchar2(5);
–删除制定的列
alter table student drop column sex ;
–修改名称
alter table student rename column stuscores to stuscore ;
–判断字段是否为空
select (case when trim(’ ‘) is not null
then ‘not null’
else ‘is null’ end)
as stuname from dual;