LOCK TABLE
LOCK TABLE
"TABLE_NAME" IN EXCLUSIVE MODE;
CONNECT BY用法
--// 一行 SELECT 顯示 0~9~A~Z select n, chr(mod(n,36)+case when mod(n,36) < 10 then 48 else 55 end) d from (Select rownum-1 as n from dual connect by level < 37) ; --// 顯示日期與星期 Select To_Date(2008 || '0101', 'yyyymmdd') + Rownum - 1 Rq, To_Char(To_Date(2008 || '0101', 'yyyymmdd') + Rownum - 1, 'day') Day From (Select Rownum From Dual Connect By Rownum <= To_Date(2008 || '1231', 'yyyymmdd') - To_Date(2008 || '0101', 'yyyymmdd') + 1); --// 取一個月的日期 Select (To_Date(2012 || '1101', 'yyyymmdd') + Rownum - 1) As everyday From Dual Connect By Rownum <= Last_Day(To_Date(2012 || '1101', 'yyyymmdd')) - To_Date(2012 || '1101', 'yyy...
留言
張貼留言