Oracle PL/SQL Ping TCP
CREATE OR REPLACE FUNCTION PING(p_HOST_NAME VARCHAR2, p_PORT NUMBER DEFAULT 1000)
發表文章
Oracle Send Email
CREATE OR REPLACE PROCEDURE SEND_MAIL(msg_to varchar2, msg_subject varchar2, msg_text varchar2) IS
.Net Settings Save 存放位置
.Net 提供了一個很好用的settings， 他可以by user去save設定值，也可以reload預設值，簡單的bind到各object的欄位， 但你知道他存到哪裡去嗎？
分析資料庫
---User BEGIN DBMS_STATS.GATHER_SCHEMA_STATS(OWNNAME => 'IMS_RM', CASCADE => TRUE); END; ----Table begin dbms_stats.gather_table_stats(ownname=> 'IMS_RM', tabname=> 'PROD_SALES_D', partname=> NULL); end; begin dbms_stats.gather_table_stats(ownname=> 'IMS_RM', tabname=> 'PROD_SALES_M', partname=> NULL); end;
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', 'yyyymmdd') + 1;
找指定Lock的Table Session
select l.*, o.owner object_owner, o.object_Name, s.LOGON_TIME from sys.all_objects o, v$lock l, v$session S where S.SID = l.SID and l.type = 'TM' and o.object_id = l.id1 and object_name in ( 'DAY_CLOSE','TICKET_M' ) order by s.LOGON_TIME