oracle jobsÅú´¦ÀíÓï¾ä
--oracle jobsÅú´¦ÀíÃüÁî²Î¿¼
qlplus /nolog
connect sys/lee as sysdba
--ÒÔÏÂÁ½¾äÔÚsys(¼´¾ßÓÐdbaȨÏÞµÄÓû§)Óû§ÏÂÖ´ÐÐ
show parameter job_queue_processes;
alter system set job_queue_processes=10;
exit
sqlplus /nolog
connect jcy/jcy
ALTER TABLE T_OA_AFFICHE MODIFY (INPUT_TIME DATE);
ALTER TABLE T_OA_AFFICHE MODIFY (MODI_TIME DATE);
--±äÁ¿
variable job1 number;
--´´½¨job
begin
dbms_job.submit(:job1,'update T_OA_AFFICHE set STATE=0 where (trunc(sysdate)-trunc(INPUT_TIME))>A_VALIDITY;',sysdate,'TRUNC(sysdate+1)');
end;
/
--Ö´ÐÐ
begin
dbms_job.run(:job1);
end;
/
--±äÁ¿
variable job2 number;
--´´½¨job
begin
dbms_job.submit(:job2,'update t_oa_affiche set a_validity=a_validity+1 where state=0;',sysdate,'sysdate+1/(24*60)');
end;
/
--Ö´ÐÐ
begin
dbms_job.run(:job2);
end;
/
exit;
Ïà¹ØÎĵµ£º
±ítask£¬×Ö¶Îid_£¬name_
id_µÄÊý¾ÝÈçÏÂÐÎʽ£º
1
1.1
1.1.1
1.1.1.2
1.2
1.2.1
...
10
10.1
10.1.1
10.2.1
10.2.1.1
10.2.1.1.1
10.2.1.1.2
.......
×¢£º“.”±êʶ¸¸×ӵĹØÏµ¡£
ÏÖÔÚͨ¹ýid_²éѯÊ÷½á¹¹µÄЧ¹û£¬²¢ÇÒÖªµÀ´Ë½ÚµãÊÇ·ñΪҶ×Ó½Úµãleaf¡£¡££¿
Óï¾äÈçÏ£º
select
......
Èí¼þÏÂÔØ
µ½http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.htmlÏÂÔØÈçÏÂÈý¸ö°ü£º
instantclient-basic-win32-11.1.0.7.0.zip
instantclient-jdbc-win32-11.1.0.7.0.zip
instantclient-sqlplus-win32-11.1.0.7.0.zip
½«ÕâÈý¸ö°ü·Ö±ð½âѹ£¬È»ºóÄÚÈݷŵ½D:\instantclient_11_1ÏÂ
......
²ã´Î»¯²éѯ£º
select [level],colomn,...from table
[where where_clause]
[ [start with start_condition] [connect by prior prior_condition]&nbs ......
1.ÓÃOracleÓû§µÇ½Linux·þÎñÆ÷;
2.ÔÚÖÕ¶Ë´°¿ÚÊäÈë sqlplus /nolog
[oracle@hylinux ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on ÐÇÆÚ¶þ 7ÔÂ 29 14:26:16 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
& ......
1¡¢OracleÀïÃæÓû§µÄÃÜÂëÊǽøÐмÓÃܱ£´æµÄ,ËùÒÔÖ»ÄÜÖØÐÂÐÞ¸ÄÉú³ÉеÄÃÜÂë.
ÀûÓÃϵͳ¹ÜÀíÔ±(sys)µÇ¼,½«scottÓû§µÄÃÜÂëÐ޸ļ´¿É
SQL>conn / as sysdba ;
ÒÑÁ¬½Ó¡£
SQL>alter user scott identified by tiger
;
Óû§ÒѸü¸Ä¡£
µ±È»Ò²¿ÉÒÔµ½WEB¶Ë½øÐÐÐ޸ĵØÖ·È ......