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

ÕÆÎÕµÄOracle¶¨Ê±ÈÎÎñ

 Ò»¡¢ÔÚPLSQLÖд´½¨±í£º
 
create table HWQY.TEST
(
CARNO VARCHAR2(30),
CARINFOID NUMBER
)
¶þ¡¢ÔÚPLSQLÖд´½¨´æ´¢¹ý³Ì£º
 
create or replace procedure pro_test
AS
carinfo_id number;
BEGIN
select s_CarInfoID.nextval into carinfo_id
from dual;
insert into test(test.carno,test.carinfoid) values(carinfo_id,''123'');
commit;
end pro_test;
Èý¡¢ÔÚSQLÃüÁî´°¿ÚÖÐÆô¶¯ÈÎÎñ£º
ÔÚSQL>ºóÖ´ÐУº
 
VARIABLE jobno number;
begin
DBMS_JOB.SUBMIT(:jobno,
''pro_test;'',
SYSDATE,''sysdate+1/24/12'');

commit;
end;
/
Ìá½»ºóÌáʾ£º
 
Ó¢ÎÄ´úÂë
ËÄ¡¢¸ú×ÙÈÎÎñµÄÇé¿ö(²é¿´ÈÎÎñ¶ÓÁÐ)£º
 
SQL> select job,next_date,next_sec,failures,broken from user_jobs;
JOB NEXT_DATE NEXT_SEC FAILURES BROKEN
---------- ----------- ---------------- ---------- ------
1 2008-2-22 ?01:00:00 0 N
 
 
˵Ã÷ÓÐÒ»¸öÈÎÎñ´æÔÚÁË¡£
Ö´ÐÐselect * from test t²é¿´¶¨Ê±ÈÎÎñµÄ½á¹û¡£¿ÉÒÔ¿´³ö¶¨Ê±ÈÎÎñÊÇÕý³£Ö´ÐÐÁ˵ġ£
 
Î塢ֹͣÒѾ­Æô¶¯µÄ¶¨Ê±ÈÎÎñ:
ÏÈÖ´ÐÐselect job,next_date,next_sec,failures,broken from user_jobs;
ÒԲ鿴¶¨Ê±ÈÎÎñµÄjobºÅ¡£
ÔÚSQL>ÖÐÖ´ÐÐÏÂÃæµÄÓï¾äÍ£Ö¹Ò»¸öÒѾ­Æô¶¯µÄ¶¨Ê±ÈÎÎñ£º
 
begin
dbms_job.remove(1);
commit;
end;
/
±íʾֹͣjobΪ1µÄÈÎÎñ¡£
Ö´ÐкóÏÔʾÈçÏ£º
 
PL/SQL procedure successfully completed
Áù¡¢²é¿´½ø³ÌÊý£º
 
show parameter job_queue_processes;
±ØÐë>0£¬·ñÔòÖ´ÐÐÏÂÃæµÄÃüÁîÐ޸ģº
alter system set job_queue_processes=5;
Æß¡¢ÔÙ´´½¨Ò»¸öÈÎÎñ(ÿ5·ÖÖÓÖ´ÐÐÒ»´Î)£º
 
variable jobno number;
begin
dbms_job.submit(:jobno, ''pro_test;'',
sysdate,''sysdate+1/24/12'');
commit;
end;
/
½¨Á¢Ò»¸ö¶¨Ê±ÈÎÎñºó£¬ÔÚPLSQLÖв鿴JOB£¬ËüµÄsqlÓï¾äÀàËÆµÄÊÇÈçÏ£º
 
begin
sys.dbms_job.submit(job => :jobno,
what => ''pro_test;'',
next_date => to_date(''21-02-2008 17:37:26'', ''dd-mm-yyyy hh24:mi:ss''),
interval => ''sysdate+1/24/12'');
commit;
end;
/
ËùÒÔ£¬´´½¨Ò»¸öÈÎÎñµÄÍêÕûµÄ¸ñʽÊÇ£º
variable jobno number;
begin


Ïà¹ØÎĵµ£º

Á½Ì¨oracleÊý¾Ý¿âÏ໥µ¼Êý¾Ý

°¸Àý˵Ã÷£º
    ÓÐA,BÁ½Ì¨oracleÊý¾Ý¿â£¬¶¼Îª10g,ÏÖÔÚÓÐÒ»¸öAÊý¾Ý¿âÖÐone±íµÄ¼¸ÌõÊý¾ÝÒª²åÈëµ½BÊý¾Ý¿âÖеÄone±í£¿
ÔÚÍøÉϲéÔÄÁËһϣ¬¿ÉÒÔͨ¹ýÔÚAÉϽ¨Á¢dblink£¬µ±È»ÔÚB»úÉϽ¨Á¢Ò²ÊÇÒ»ÑùµÄ¡£
´ò¿ªsqlplusÖÕ¶Ë£¬»òÕßÈÎÒâµÄoracle¿Í»§¶Ë»·¾³£¬Ö´ÐÐÒÔÏÂSQL
create database link Á´½ÓÃû 
¡¡connect t ......

Introduction to Oracle Wait Interface notes

     ÎÄÕÂÌáµ½£¬ÓÃCache hit ratioµÄ·½·¨À´¼ì²éORACLEÐÔÄÜÎÊÌâ¹ýʱÁË£¬ÀïÃæÓоä·Ç³£ÐÎÏóµÄ»°£ºÕâÎÞÒìÓÚÒ»¸öÒ½ÉúÖ»ÖªµÀ¸ù¾ÝѪѹµÄÀ´ÖÎÁƲ¡ÈË£¬¶ø²¡ÈËÓÉÓÚÌÛÍ´£¬Éñ¾­ÐË·Ü£¬ÑªÑ¹ÔÚÒ»¸öºÏÀíµÄ·¶Î§ÄÚ£¬Ò½ÉúÈ´¸æËß»¼Õߣ¬Äãû²¡£¬µÈÄãѪѹµÍµÄʱºòÔÙÀ´¡£Í¬ÑùµÄ£¬ÎÒÃDz»Äܽö½ö¸ù¾ÝCache hit ratioÀ´ÅжÏORACLEÊ ......

Oracle¡¢SQL Server¡¢AccessÊý¾Ý¿â¸ßЧ¹û·ÖÒ³¼¼ÇÉ

 ÔÚ³ÌÐòµÄ¿ª·¢¹ý³ÌÖУ¬´¦Àí·ÖÒ³ÊÇ´ó¼Ò½Ó´¥±È½ÏƵ·±µÄʼþ£¬ÒòΪÏÖÔÚÈí¼þ»ù±¾É϶¼ÊÇÓëÊý¾Ý¿â½øÐйҵöµÄ¡£µ«Ð§ÂÊÓÖÊÇÎÒÃÇËù×·ÇóµÄ£¬Èç¹ûÊÇÏñÔ­À´ÄÇÑù°ÑËùÓÐÂú×ãÌõ¼þµÄ¼Ç¼ȫ²¿¶¼Ñ¡Ôñ³öÀ´£¬ÔÙÈ¥½øÐзÖÒ³´¦Àí£¬ÄÇô¾Í»á¶à¶àµÄÀ˷ѵôÐí¶àµÄϵͳ´¦Àíʱ¼ä¡£ÎªÁËÄܹ»°ÑЧÂÊÌá¸ß£¬ËùÒÔÏÖÔÚÎÒÃǾÍֻѡÔñÎÒÃÇÐèÒªµÄÊý¾Ý£¬¼õÉÙÊý¾Ý ......

ÈçºÎ½«TXT,EXCEL»òCSVÊý¾Ýµ¼ÈëORACLEµ½¶ÔÓ¦±íÖÐ

 ·½·¨Ò»£¬Ê¹ÓÃSQL*Loader  
  Õâ¸öÊÇÓõĽ϶àµÄ·½·¨£¬Ç°Ìá±ØÐëoracleÊý¾ÝÖÐÄ¿µÄ±íÒѾ­´æÔÚ¡£  
  ´óÌå²½ÖèÈçÏ£º  
  1   ½«excleÎļþÁí´æÎªÒ»¸öÐÂÎļþ±ÈÈçÎļþÃûΪtext.txt£¬ÎļþÀàÐÍÑ¡Îı¾Îļþ£¨ÖƱí·û·Ö¸ô£©£¬ÕâÀïÑ¡ÔñÀàÐÍΪcsv£¨¶ººÅ·Ö¸ô£©Ò²ÐУ¬µ«ÊÇÔÚдºóÃæµÄcontrol. ......

oracleʵ¼ù

1.
´íÎóÌáʾ£ºORA-12545:ÒòÄ¿±êÖ÷»ú»ò¶ÔÏó²»´æÔÚ,Á¬½Óʧ°Ü.
´íÎóÖ¢×´£ºÐ½¨µÄÊý¾Ý¿âÔÚOEM¿ØÖÆÌ¨ÎÞ·¨ÏÔʾ£¨sysmanÓû§µÇ½£©£¬¶ÀÁ¢Æô¶¯Ä£Ê½¿ÉÒÔÕÒµ½£¬µ«ÎÞ·¨µÇ½£¬³öÏÖÈçÉÏ´íÎó¡£
½â¾ö°ì·¨£ºÐÞ¸Äoracle°²×°Ä¿Â¼Ï£¨oracle\ora90\network\ADMIN£©µÄtnsnames.oraÎļþ£¬½«µ±Ç°Êý¾Ý¿âÌí¼Óµ½¼àÌý¶ÔÏóÖС£ÐÞ¸ÄÖ®ºó£¬¿ÉÒÔÔÚ¶ÀÁ¢Ä ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ