Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ORACLE JOB¼ä¸ôʱ¼ä²Î¿¼

 
¹Ø¼ü×Ö: oracle job ¼ä¸ôʱ¼ä trunc
¼ÙÉèÄãµÄ´æ´¢¹ý³ÌÃûΪPROC_RAIN_JM
ÔÙдһ¸ö´æ´¢¹ý³ÌÃûΪPROC_JOB_RAIN_JM
ÄÚÈÝÊÇ£º
Create Or Replace Procedure PROC_JOB_RAIN_JM   Is   li_jobno         Number;   Begin   DBMS_JOB.SUBMIT(li_jobno,'PROC_RAIN_JM;',SYSDATE,'TRUNC(SYSDATE + 1)');    End;  
Ìá½»jobÓï·¨£º
begin   sys.dbms_job.submit(job => :job,                         what => 'P_CLEAR_PACKBAL;',                         next_date => to_date('04-08-2008 05:44:09', 'dd-mm-yyyy hh24:mi:ss'),   interval => 'sysdate+ 1/360');   commit;   end;  
£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­
´´½¨JOB
variable jobno number;   begin   dbms_job.submit(:jobno, 'P_CRED_PLAN;',SYSDATE,'SYSDATE+1/2880',TRUE);   commit;  
ÔËÐÐJOB
begin       dbms_job.run(:job1);   end;  
ɾ³ýJOB
begin       dbms_job.remove(:job1);   end;  
DBA_JOBS
£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½
×ֶΣ¨ÁУ©          ÀàÐÍ                 ÃèÊö
JOB                NUMBER          ÈÎÎñµÄΨһ±êʾºÅ
LOG_USER        


Ïà¹ØÎĵµ£º

Oracle SQLÓï¾ä²Ù×÷Êý×Ö£ºÈ¡Õû¡¢ËÄÉáÎåÈë¼°¸ñʽ»¯

 http://cheneyph.javaeye.com/blog/453492
ÓÃoracle sql¶ÔÊý×Ö½øÐвÙ×÷: È¡ÉÏÈ¡Õû¡¢ÏòÏÂÈ¡Õû¡¢±£ÁôNλСÊý¡¢ËÄÉáÎåÈë¡¢Êý×Ö¸ñʽ»¯
È¡Õû£¨ÏòÏÂÈ¡Õû£©£º 
select floor(5.534) from dual;
select trunc(5.534) from dual;
ÉÏÃæÁ½ÖÖÓ÷¨¶¼¿ÉÒÔ¶ÔÊý×Ö5.534ÏòÏÂÈ¡Õû£¬½á¹ûΪ5.
Èç¹ûÒªÏòÉÏÈ¡Õû £¬µÃµ½½á¹ûÎ ......

PHPÁ¬½ÓOracle²¢·ÖÒ³·ÃÎÊ(OCI°æ)

ËäÈ»±¾ÈËûÓÐÑéÖ¤¹ý,²»¹ý¾Ý˵ͨ¹ýADODB·ÃÎÊOracle¶ÔÐÔÄÜÓ°ÏìºÜС.¶øÇÒADODB±ÈOCI8Ò²Òª·½±ãºÜ¶à,±Ï¾¹Ðí¶à¶«Î÷¶¼Ôٴηâ×°¹ý.²»¹ý²»¹ÜÔõô˵ÕⶼÔÚÖмäÓÖ¼ÓÉÏÁËÒ»²ã,ÀíÂÛÉÏÀ´Ëµ³öÏÖÎÊÌâµÄ¼¸Âʺͽâ¾öÎÊÌâµÄÄѶȶ¼±ä´óÁË.¶øOracleÓÖ¾­³£ÓÃÔÚ²»ÄÜËæ±ã³öÎÊÌâµÄ»·¾³,ËùÒÔÏë±ØÏëÒªÖ±½ÓʹÓÃOCIµÄÇé¿öÒ²²»ÉÙ.ÒÔϾÍÊÇÎÒµÄÀý×Ó:
<?p ......

oracle ʱ¼ä²î


 //¼ÆËãºÁÃë²î(Á½¸ödateÀàÐ͵ÄÏà¼õΪÌìÊý²î±ð£¬È»ºóת»»ÎªºÁÃë)
select ceil(to_date('209-11-17 13:00:12','yyyy-mm-dd hh24:mi-ss')-to_date(2009-11-18 14:00:12','yyyy-mm-dd hh24:mi-ss') )from dual;
//¼ÆËãÏà²îÔ·Ý
select (EXTRACT(year from to_date('209-11-17','yyyy-mm-dd'))-EXTRACT(year from  ......

¹ØÓÚoracleÊý¾Ý¿â°²×°²»ÄÜ×ÔÐÐÅäÖÃÊý¾Ý¿âµÈÎÊÌâ


³õ³õѧϰoracle 10g,×î»ù±¾µÄÎÊÌâ¾ÍÊÇ°²×°Êý¾Ý¿â,³õ³õ°²×°Êý¾Ý¿âʱ,°²×°Óë±ðÈ˵Ķ¼²î²»¶à,¾ÍÊÇÔÚ×îºóʱ,²»ÄÜ×ÔÐÐÅä×°Êý¾Ý¿â,Òª×Ô¼ºÅäÖÃÊý¾Ý¿â,×îºó¾­¹ý×Ô¼ºµÄÅŲé:ÔÚ°²×°ÏµÍ³Ê±,ϵͳµÄ¼ÆËã»úÃû³Æ(×¢²á¼ÆËã»úʱÓõÄ)ΪӢÎÄ,Óû§Ãû³ÆΪÖÐÎÄ,Òò´Ë²»ÄÜ×ÔÐÐÅäÖÃÊý¾Ý¿â,
¾­¹ý±¾È˵Ķà´ÎʵÑé,ÔÚ¼ÆËã»úÃû³Æ¡¢Óû§ÃûΪӢÎĵÄ×´Ì¬Ï ......

Oracle´¥·¢Æ÷(¸ÅÄîºÍÀàÐÍ)

1.       ÒýÑÔ
 
2.       ´¥·¢Æ÷µÄ¸ÅÄîºÍÀàÐÍ
´¥·¢Æ÷ÊÇÒ»ÖÖÌØÊâµÄ´æ´¢¹ý³Ì£¬ËüÔÚ²åÈ룬ɾ³ý»òÐÞ¸ÄÌض¨±íÖеÄÊý¾Ýʱ´¥·¢Ö´ÐУ¬Ëü±ÈÊý¾Ý¿â±¾Éí±ê×¼µÄ¹¦ÄÜÓиü¾«Ï¸ºÍ¸ü¸´ÔÓµÄÊý¾Ý¿ØÖÆÄÜÁ¦¡£Êý¾Ý¿â´¥·¢Æ÷ÓÐÒÔϵÄ×÷Óãº
* °²È«ÐÔ¡£¿ÉÒÔ»ùÓÚÊý¾Ý¿âµÄÖµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ