-------按星期统计
select to_char(t.fsendedouttime, 'DY'), count(t.fsendedouttime)
from deppon009.t_inf_smssendedoutbox2 t
group by to_char(t.fsendedouttime, 'DY')
order by to_char(t.fsendedouttime, 'DY');

1 星期一 337632
2 星期三 378073
3 星期二 413559
4 星期五 441565
5 星期六 412940
6 星期四 432146
7 星期日 309050

C# Convert String To GUID

Guid guid = new Guid("2b1ee12d-8056-4f44-bf5a-412d3cb8f948");

rem -----------------------------------------------------------------------
rem Filename:   temptab.sql
rem Purpose:    Demonstrate Oracle 8i temporary tables
rem Date:       23-Apr-2000
rem Author:     Frank Naude, Oracle FAQ
rem -----------------------------------------------------------------------

drop table x
/

create global temporary table x (a date)
        on commit delete rows     -- Delete rows after commit
      

rem -----------------------------------------------------------------------
rem Filename:   maxvalue.sql
rem Purpose:    Select the Nth highest value from a table
rem Date:       18-Apr-2001
rem Author:     Deepak Rai, SSE, Satyam Computer Services Ltd. India
rem -----------------------------------------------------------------------

select level, max('col_name') from my_table
where level = '&n'
connect by prior ('col_name') > 'col_name')
group by level;

-- Example :
--
-- 

rem -----------------------------------------------------------------------
rem Filename:   encode.sql
rem Purpose:    Demonstrate simple encoding and decoding of secret messages 
rem             This method can be extended to create simple password
rem             encryption
rem Date:       15-Feb-2001
rem Author:     Frank Naude, Oracle FAQ
rem -----------------------------------------------------------------------

SELECT TRANSLATE(
        'HELLO WORLD',                  -- Mess

http://www.oracle-erp.net/category-4

欧盟无条件批准Oracle公司对Sun收购案的消息，实际上宣告了一个伟大公司的离去。

Java之父James Gosling在自己的博客贴出了一幅画，应该代表了许多技术人的心情：

http://www.youku.com/playlist_show/id_2813442.html