用PL/SQL创建一个图书表

创造一个名为“book”的表

–创建图书表
create table book
(
no varchar2(64),
name varchar2(10),
author varchar2(10),
category varchar2(10)
);

–插入数据–insert into 表名(各个列明)
–values(各列对应的值)
insert into book (no,name,author,category)values(‘001’,‘简爱’,‘夏洛蒂’,‘文学小说’);
insert into book (no,name,author,category)values(‘002’,‘平凡的世界’,‘路遥’,‘文学小说’);
insert into book (no,name,author,category)values(‘003’,‘物种起源’,‘达尔文’,‘生物学’);
insert into book (no,name,author,category)values(‘004’,‘意林’,‘文学联合会’,‘杂志’);

–查询数据
–select 列名 from 表名 [where 筛选条件]
select no,name,author,category from book where name=‘简爱’;
select * from book
查询书名为“简爱”的图书
–修改语句
–update student set 列名=值 [where 筛选条件]
update book set category=‘杂志’ where name=‘中国文学’;
select * from book

–删除语句
–delete from 表名 [where 筛选条件]
delete from book where name=‘物种起源’;
select * from book
删除书名为“物种起源”的图书