如何在oracle中定制一个job
如何在oracle中定制一个job完成想要完成功能:
Connected to Oracle9i Enterprise Edition Release 9.2.0.1.0
Connected as system
--创建过程如下:
create or replace procedure p_test as
LV_SQL varchar2(200);
begin
LV_SQL := 'truncate table catantest';
EXECUTE IMMEDIATE LV_SQL;
end p_test;
SQL> select * from catantest;
DEPTNO DNAME LOC
------ -------------- -------------
SQL> insert into catantest select * from depttest;
7 rows inserted
SQL> commit;
Commit complete
SQL> variable jobcatan number;
SQL> begin
2 dbms_job.submit(:jobcatan,'P_TEST;',sysdate,'sysdate + 5/(24*60)');
3 commit;
4 end;
5
6 /
PL/SQL procedure successfully completed
jobcatan
---------
3
SQL> begin
2 dbms_job.run(:jobcatan);
3 end;
4 /
PL/SQL procedure successfully completed
jobcatan
---------
3
SQL> select * from catantest;
DEPTNO DNAME LOC
------ -------------- -------------
SQL> insert into catantest select * from depttest;
7 rows inserted
SQL> commit;
Commit complete
SQL> select * from catantest;
DEPTNO DNAME LOC
------ -------------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS
11 11 11
12 11
相关文档:
1、在oracle的sys-sysdba下登陆
写一个java source程序链接sqlserver2005:
create or replace and compile java source named test as
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
public class excutesql1
{
public static String entry ......
Oracle函数和mysql函数比较
1. Oracle中的to_number()转换成数字;
Oracle> Select to_number(‘123’) from dual; ----- 123;
&nbs ......
update :单表的更新不用说了,两者一样,主要说说多表的更新
Oracle> Oracle的多表更新要求比较严格,所以有的时候不是很好写,我们可以试试Oracle的游标
&n ......
【51CTO.com独家特稿】面对惊慌的客户和广泛质疑的媒体,Oracle官方最近终于出榜安民,那便是一个以“SUN CUSTOMERS ,Oracle Plans To:”为大标题的广告。直译过来便过来可知道,Oracle将要加大SPARC和Solaris的投入了,而大老板埃里森也向IBM硬件下了战书,声称Oracle将最终赢得这场竞争……
&n ......
我在把oracle数据导入sqlserver中时,发现在oracle中字段定义为唯一索引时,不同记录的此字段如果为空不被认为是重复的,但在sqlserver中如果此字段为唯一索引字段,不允许有2个以上的空值。郁闷。所以只好将sqlserver中的唯一索引字段手工修改为几个非空的值,但这样程序肯定要进行修改了。需要在程序中为此字段设置不重复 ......