luckyleaves.blogspot.com
太阳与月亮同存的星球: February 2006
http://luckyleaves.blogspot.com/2006_02_01_archive.html
Tuesday, February 28, 2006. 1 round(86.678,2)from dual. 2select title,upper(cd number)as "DJ on Demand Collections". 3select lower(last name) ' substr(upper(first name),1,1)as "User Passwords". 4select replace('HELLO WORLD','It is a small world'). 5select substr('fiddledeedum',1,9) substr ('fiddledeedee',7,6)as "Nonsense". 6select replace('mississpippi','i','$'). 7select round(5332.342,-2)from dual. 8select round(3.14159,2)from dual. 9select trunc(73.892,1)from dual. 14select title,year from d cds. 9sele...
luckyleaves.blogspot.com
太阳与月亮同存的星球: April 2006
http://luckyleaves.blogspot.com/2006_04_01_archive.html
Friday, April 21, 2006. 2select id,title,duration,artist. Where type code in (select code. Where description in('Jazz','Pop'). 4select last name,salary. Where salary = any (select min(salary). 5select employee id,last name,salary. 6a Which CDs in our d cds collection were produced before "Carpe Diem" was produced? B Which employees have salaries lower than any one of the programmers in the IT department? C What CD titles were produced in the same year as "Party Music for All Occasions" or "Carpe Diem"?
luckyleaves.blogspot.com
太阳与月亮同存的星球: September 2005
http://luckyleaves.blogspot.com/2005_09_01_archive.html
Sunday, September 25, 2005. There is a big cultural difference between china and America. I lived in china for more than 17 years. The Chinese culture is a part of my life. A big change took place after I moved to America. Now I am starting a new life in America. When I was still on the plane before arriving in America, I felt very excited and happy. After I arrived in America, I felt that it is very hard for my new beginning. Time flys day by day. I learn more and more culture and customs in America...
luckyleaves.blogspot.com
太阳与月亮同存的星球: March 2006
http://luckyleaves.blogspot.com/2006_03_01_archive.html
Sunday, March 19, 2006. 21Select cd number title. Where cd number =94;. 2Select concat(cd number,title). Where cd number =94;. 3aF bF c.F d.T e.F f.T g.T. 4Select to char(cost, '$999999.99') from d events;. 5Select lpad(id,2,'*') from f staffs where id. 6Select '15-DEC-95' from dual. 7Select to char('19-Jun-04','ddth "of" fmmonth year' from dual. 8Select substr('Oracle Academy',14,14) from dual. WHERE loc type LIKE 'National Park'. AND ID = 200;. WHERE loc type LIKE 'National Park'. OR ID = 200;. Part2se...
luckyleaves.blogspot.com
太阳与月亮同存的星球: May 2006
http://luckyleaves.blogspot.com/2006_05_01_archive.html
Monday, May 01, 2006. 11 create o employees. As (select* from employees). 12 create o departments. As (select * from departments). 12 create o jobs. As (select * from jobs). 2insert into o jobs(id,job title,job id,max salary,min salary). Values(210,'Human Resources Mamager','HR MAN',5500,4500). 3insert into o employees. Emoloyee id,first name,last name,email address,hire date). Values(210,'Ramon','Sanchez','RSANCHEZ',sysdate). 4insert into o employees. Values(210,'Ramon','Sanchez','RSANCHEZ',sysdate).