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;
2、模糊匹配时忽略大小写
select * from table_name where lower(column_name) like lower('%a%');
3、去除某一列的尾部空格
update table_name set column_name=trim(column_name);