oracle使用小經驗
1、新增job的sql語句DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => 'your_procedure_name;'
,next_date =>''
,interval => 'TRUNC(sysdate)+1+1/24' --execute time
,no_parse => FALSE
);
SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));
COMMIT;
END;
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => 'your_procedure_name;'
,next_date =>''
,interval => 'TRUNC(sysdate)+1+1/24' --execute time
,no_parse => FALSE
);
SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));
COMMIT;
END;
2、模糊匹配時忽略大小寫
select * from table_name where lower(column_name) like lower('%a%');
3、去除某一列的尾部空格
update table_name set column_name=trim(column_name);
posted on 2010-04-14 15:20 此號已被刪 閱讀(296) 評論(0) 編輯 收藏 所屬分類: Oracle