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
Ïà¹ØÎĵµ£º
ÊÂÎñ¾ÍÊDZ»°ó¶¨ÔÚÒ»Æð×÷Ϊһ¸öÂß¼¹¤×÷µ¥ÔªµÄSQLÓï¾ä·Ö×飬Èç¹ûÈκÎÒ»¸öÓï¾ä²Ù×÷ʧ°ÜÄÇôÕû¸ö²Ù×÷¾Í±»Ê§°Ü£¬ÒÔºó²Ù×÷¾Í»á»Ø¹öµ½²Ù×÷ǰ״̬£¬»òÕßÊÇÉÏÓиö½Úµã¡£ÎªÁËÈ·±£ÒªÃ´Ö´ÐУ¬ÒªÃ´²»Ö´ÐУ¬¾Í¿ÉÒÔʹÓÃÊÂÎñ¡£ÊÂÎñÓÐËĸöÌØÐÔ£¬·Ö±ðÊÇ£ºÔ×ÓÐÔ£¬Ò»ÖÂÐÔ£¬¸ôÀëÐԺͳ־ÃÐÔ¡£
Ë÷Òý¾ÍÒ»ÖÖÌØÊâµÄ²éѯ±í£¬Êý¾Ý¿âµÄËÑË÷ÒýÇæ¿ ......
ÏÂÃæÊÇÓÃscottÓû§²âÊԵġ£
Èç¹û²»ÖªµÀµ±Ç°Óû§ÊÇʲôÓû§,¿ÉÒÔÊäÈë: show user ,ÕâÑùËü¾ÍÏÔʾ³öµ±Ç°Óû§ÊÇʲôÓû§ÁË.
Èç¹ûÏë±à¼ÒѾÊäÈëµ½sqlplusÖеĴúÂë,¿ÉÒÔÊäÈë“ed”£¬È»ºó»Ø³µ¾ÍÄܵ¯³öÒ»¸ö¼Çʱ¾£¬¼Çʱ¾ÀïÃæÓÐÉÏÒ»²½ÊäÈëµÄ´úÂë,Ð޸ĴúÂë²¢±£´æºó¹Ø±Õ¼Çʱ¾,×îºóÔÚsqlplusÖÐÊäÈë“/”²¢»÷»Ø ......
¿ÉÒÔʹÓÃGROUPING_IDº¯Êý½èÖúHAVING×Ó¾ä¶Ô¼Ç¼½øÐйýÂË£¬½«²»°üº¬Ð¡¼Æ»òÕß×ܼƵļǼ³ýÈ¥¡£GROUPING_ID()º¯Êý¿ÉÒÔ½ÓÊÜÒ»Áлò¶àÁУ¬·µ»ØGROUPINGλÏòÁ¿µÄÊ®½øÖÆÖµ¡£GROUPINGλÏòÁ¿µÄ¼ÆËã·½·¨Êǽ«°´ÕÕ˳Ðò¶ÔÿһÁе÷ÓÃGROUPINGº¯ÊýµÄ½á¹û×éºÏÆðÀ´¡£
¹ØÓÚGROUPINGº¯ÊýµÄʹÓ÷½·¨¿ÉÒԲμûÎÒÇ°ÃæдµÄһƪÎÄÕÂ
http://blog.csdn ......
Ë÷Òý( Index )Êdz£¼ûµÄÊý¾Ý¿â¶ÔÏó£¬ËüµÄÉèÖúûµ¡¢Ê¹ÓÃÊÇ·ñµÃµ±£¬¼«´óµØÓ°ÏìÊý¾Ý¿âÓ¦ÓóÌÐòºÍDatabase µÄÐÔÄÜ¡£ËäÈ»ÓÐÐí¶à×ÊÁϽ²Ë÷ÒýµÄÓ÷¨£¬ DBA ºÍ Developer ÃÇÒ²¾³£ÓëËü´ò½»µÀ£¬µ«±ÊÕß·¢ÏÖ£¬ ......
1£®Êýѧº¯Êý
¢Ù¾ø¶ÔÖµ
l S£ºselect abs(-1) value
l O£ºselect abs(-1) value from dual
¢ÚÈ¡Õû(´ó)
l S£ºselect ceiling(-001) value
l O£ºselect ceil(-001) value from dual
¢ÛÈ¡Õû£¨Ð¡£©
l S£ºselect floor(-001) value  ......