Oracle sql1 2010.10.10

select * from books;
select * from author;
select isbn,title from books;
select firstname,lastname,address from customers;
select category as "种类",title "书名" from books;
select retail-cost as "利润" from books;
select cost*1.1 as "newCost" from books;
select cost*1.1 as "newCost" from books order by cost asc;
select state from customers order by state asc;
select distinct state from customers order by state asc;
select unique state，firstname from customers order by state asc;
select distinct city,state from customers order by city asc;
select firstname||' ' ||lastname as "姓名" from customers;
select lname||','||fname from author;

chaper 4
select * from books where category='COMPUTER';
select * from customers where state = 'CA' order by customer# asc;

select isbn,title,cost from books where cost>20 order by cost;
select isbn,title,retail-cost from books where retail-cost>10 order by retail-cost;

select * from books where ISBN='1915762492';

select pubdate from books where pubdate='21-1月 06';
select pubdate from books where pubdate=TO_DATE('2006/1/21','YYYY/MM/DD');
select pubdate ,to_char(pubdate,'YYYY-MM-DD') from books;

select distinct state from customers where state != 'FL' order by state;
select distinct state from customers where state >='FA' order by state ;

select * from books where cost between 19 and 30 order by cost;
select * from customers where state in ('FL','CA');
select * from books where category in ('COOKING','COMPUTER') order by category;


Create view newbooks (title) as select title from books;
select title from newbooks;
DROP VIEW newbooks; 

select table_name from tabs;
select table_name from all_tables;