敗家貓

[oracle@mar bdump]$ sqlplus /nolog

SQL*Plus: Release 10.1.0.2.0 - Production on Fri Mar 24 
10:43:41 2006

Copyright (c) 1982, 2004, Oracle.  All rights reserved.

...繼續閱讀

今天早上去考oracle 007的考試，考的還好86.5%過關。不過還有3門要努力，要再加油~再加油
...繼續閱讀

來源:http://www.cnoug.org/viewthread.php?tid=15169&highlight=TRUNCATE&page=1
TRUNCATE,delete,drop的異同點 
注意:這裡說的delete是指不帶where子句的delete語句
...繼續閱讀

來源:http://www.faqts.com/knowledge_base/view.phtml/aid/16331/fid/148
...繼續閱讀

看到不錯的basd sql
http://blog.chinaitlab.com/user1/263089/archives/2005/28062.html
...繼續閱讀

如不要copy資料的話，那就可以加上where的條件試
create table copy_oracle_test  as select * from employees [where 1=2];

mysql 5.0以上測過ok
crearte table copy_mysql_test  select * from employees [where 1=2] ; ...繼續閱讀

來源:http://www.dbasupport.com/oracle/ora9i/caseExpression01.shtml

多看別人的code也是讓自已進步的一個方法~

...繼續閱讀

select count(*) total,
sum(decode(to_char(hire_date,'yyyy'),1995,1,0)) "1995",
sum(decode(to_char(hire_date,'yyyy'),1996,1,0)) "1996",
sum(decode(to_char(hire_date,'yyyy'),1997,1,0)) "1997",
sum(decode(to_char(hire_date,'yyyy'),1998,1,0)) "1998"
from employees;


select count(hire_date),
sum(case when to_char(hire_date,'yyyy')='1995' then 1 end ) as "1995",
sum(case when to_char(hire_date,'yyyy')='1996' then 1 end ) as "1996",
sum(case when to_char(hire_date,'yyyy')='1997' then 1 end ) as "1997",
sum(case when to_char(hire_date,'yyyy')='1998' then 1 end ) as "1998"
from employees
...繼續閱讀