create table book (id varchar2(13),
name varchar2(20),
zuozhe varchar2(10),
price number(6,2));

insert into book values('1','c++實用技術','Tomcat',45);
insert into book values('2','C++入門','張飛',45);
insert into book values('1','深入淺出c++','侯捷',65);
insert into book values('4','java實用技術','Tomcat',45);
insert into book values('5','實戰Java技能','Kate',45);
insert into book values('6','thinking in c++','bell',45);

--查詢所有關于c++的圖書

select * from book where name like '%c++%' or name like '%C++%';

思考：如果找出所有關于java的圖書當如何？

--查詢所有關于c++的圖書,并按書號，價格排序。

select * from book where name like '%c++%' or name like '%C++%' 
order by id, price desc;