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

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;


Ïà¹ØÎĵµ£º

Oracle³õѧÕß±ØÖªµÄ100¸öÒÉÎÊ

1. Oracle°²×°Íê³ÉºóµÄԭʼ¿ÚÁ
¡¡internal/oracle
¡¡¡¡sys/change_on_install
¡¡¡¡system/manager
¡¡¡¡scott/tiger
¡¡¡¡sysman/oem_temp
2. ORACLE9IAS WEB CACHEµÄԭʼĬÈÏÓû§ºÍÃÜÂ룿
administrator/administrator
3. oracle 8.0.5ÈçºÎ½¨Á¢Êý¾Ý¿â£¿
ÓÃorainst¡£¼ÙÈçÓÐmotif½çÃæ£¬Äܹ»ÓÃorainst /m¡ ......

OracleɱµôËÀËø½ø³Ì

ÓÃOracle Sql Developer²Ù×÷±íµÄʱºò£¬²»ÖªÕ¦µÄ°Ñ±íËø×¡ÁË¡£
½á¹ûÄÇÕűíÒ»²åÊý¾Ý¾ÍËÀ£¬Á¬truncate¶¼²»ÐС£
´ÓÍøÉÏÆßÆ´°Ë´ÕÁ˸ö·½·¨£¬ÖÕÓڰѽø³ÌɱÁË£¬±íÒ²¾Í½âËøÁË¡£
Ê×ÏÈÒªÓÃdba¼¶±ðµÄÓû§²Ù×÷£¬ÒòΪҪ²ì¿´ºÜ¶àϵͳ±í¡£ÓÃÆÕͨÓû§²Ù×÷µÄ»°£¬»áÌáʾ±í»òÕßView²»´æÔÚ¡££¨ÎªÊ²Ã´²»ÌáʾȨÏÞ²»¹»£¿º¦ÎÒ×ÜÒÔΪÊǰ汾ÎÊÌ⣩
È ......

OracleÇý¶¯classes12.jar Óëojdbc14.jarµÄÇø±ð

ÒÔÏÂÊÇOracle JDBC¹Ù·½ÎĵµµÄ˵·¨£º
Ò²¾ÍÊÇËæ±ã·­ÒëһϾÍÀí½âÁË¡£
JDBC Thin for All Platforms
classes12.jar (1,600,090 bytes) - for use with JDK 1.2 and JDK 1.3
Ôڵͼ¶JDK°æ±¾1.2Óë1.3ÖÐʹÓõÄÇý¶¯£¬ËäȻʵ¼ÊÉÏÔÚ1.4£¬1.5ÖÐʹÓô󲿷ÖÇé¿öÒ²ÊÇOKµÄ
classes12_g.jar (2,044,594 bytes) - same as classes12.j ......

oracleÊý¾ÝÎļþ»Ö¸´

1.    ×¼±¸¹¤×÷
°Ñ¾ÉµÄORACLEËùÓÐÎļþ¶¼COPY±¸·ÝÏÂÀ´,ɾ³ý¾ÉĿ¼,ÔÙÖØÐ°²×°ORACLE,Ŀ¼ºÍ¾ÉĿ¼һÑù(Èç¹û²»Ò»Ñù,ÒªÐ޸ĵĵط½±È½Ï¶à).Ö»°²×°ORACLE,²»´´½¨Êý¾Ý¿â¡£Òª»Ö¸´µÄʵÀýΪORCL ¡£
2.ÓÃÃüÁʽ£¬Í¨¹ýÒª¾ÉµÄORAÎļþ´´½¨ÐµÄʵÀýORCL
a)     oradim -new -sid ORCL£¨´´½¨ÊµÀý£ ......

oracle instr


¶ÔÓÚinstrº¯Êý£¬ÎÒÃǾ­³£ÕâÑùʹÓ㺴ÓÒ»¸ö×Ö·û´®ÖвéÕÒÖ¸¶¨×Ó´®µÄλÖá£Àý
È磺
SQL> select
instr('yuechaotianyuechao','ao') position from dual;
 
  POSITION
----------
        
6
 
´Ó×Ö·û´®'yuechaotianyuechao'µÄµÚÒ»¸öλÖÿªÊ¼£¬Ïòºó² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ