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

ѧºÃORACLEÓ¦ÔõÑùÀ´Ñ§Ï°Ó¢Óï

ѧϰORACLEÒ²¿ìÒ»ÄêÁË£¬µ½ÏÖÔÚ¶¼¶ÔORACLEµÄϵͳ֪ʶÁ˽âµÃºÜÉÙ£¬Ò»Ö±ÏëÌá¸ß×Ô¼ºµÄ¼¼Êõˮƽ£¬Æ½Ê±¶¼ÊÇÔÚ¿´±ðÈ˵ÄBLOBÖÐѧϰ£¬»¹ÊÇѧµ½Á˲»ÉÙ֪ʶ£¬µ«ÎÒ×Ô¼ºÓ¢ÓïÕæµÄºÜ²îºÜ²î£¬ORACLEµÄ¹Ù·½ÎĵµÒ»µãÒ²¿´²»¶®¡£ÎÒÊÇÒ»µã»ùÓï»ù´¡¶¼Ã»Óе쬰¥£¬ÒÔǰ¶ÁÊéµÄʱºò²»ÈÏÕæ¡£¡£¡£¡£ÏÖÔÚÎÒ²»ÖªÓÃʲô·½Ê½À´²¹ÎÒµÄÓ¢ÓÏÖÔÚÓÐÁ½¸öÏë·¨£¬ÏÈÈ¥Ó¢ÓïѧУѧµãÓ¢Óï»ù´¡£¨Ð¸ÅÄî1£¬2²á°É£©ÔÙÀ´¿´ORACLEµÄÓ¢ÎÄÎĵµ£¬»¹ÊÇÖ±½Ó¾Í¿´ORACLEµÄÓ¢ÎÄÎĵµ£¨µ«Óï·¨Ò»µãÒ²²»ÖªµÀ£¬Éϴο´ÁËÒ»µã£¬Ñ§Ï°ÆðÀ´ºÜ³ÔÁ¦£¬Ò²Ã»Óз½·¨£©¡£Çë´ó¼Ò¸øÎÒÒ»µã½¨Ò飬ÎÒÖ»ÒªÄÜ¿´¶®ORACLEµÄÎĵµ¾ÍÐС£¡£¡£¡£ºÇ£¬ÎÒÊÇÒ»µãÓ¢Óï»ù´¡¶¼Ã»ÓеÄÈ˹þ£¬Çë¸ßÊÖÃÇÖ¸µãÒ»ÏÂÃ÷·£¬Ð»Ð»´ó¼ÒÁË
²»¹Ü¿´µÄÊÇʲô·½ÃæµÄÓï¾äÊé¼®£¬Äã¶¼ÖÁÉÙÐèҪѧ»á»ù´¡µÄÓ¢Óï´Ê»ãºÍÓï·¨
ÔÙѧϰÄǸö·½ÃæµÄÊõÓï
ÂýÂýÀ´°É£¬Ò»µã»ù´¡¶¼Ã»Óеϰ²»¿ÉÄÜÒ»²½µÇÌìµÄ
¶à¿´¿´Ó¢ÓïÔÓÖ¾ºÍÎĵµ
²»¶®µÄ²é´Êµä£¬½ðɽ´Ê°ÔÊǸö²»´íµÄ¸¨Öú¹¤¾ß
¿ªÊ¼»áºÜÀ§ÄÑ£¬¼á³ÖÏÂÀ´

ÎÒÏÖÔÚ¾ÍÊÇÁ¬Óï·¨Ò»µã¶¼²»ÖªÊ¶£¬Ó¦¸Ã´ÓºÎѧÆðÄØ£¿ÓбØÒª²Î¼Ó¸ö³õ¼¶µÄÅàѵÂð£¿



ÎÒ¸Õ±ÏҵʱȥµÄÒ»¼ÒÍâÆó(С¹«Ë¾£¬×¨ÃÅ×öÃÀ¹úµÄÊý¾Ý¿â)¡£ÄÇʱ»¹ÊÇ´ó¶þ¹ýµÄËļ¶£¬È»ºó¾Íû¿´¹ýÓ¢ÓïÁË¡£Ôç¾ÍÍüµÄ²î²»¶àÁË¡£µ±Ê±ÎÒÊÇд¸öûÓÐÓï·¨´íÎóµÄ¾ä×Ó¶¼³ÉÎÊÌâ¡£ÀϰåÔÚÃÀ¹ú£¬Æ½Ê±Ò²¶¼Êǵ绰ÁªÏµ¡£¹¤×÷½»Á÷¶¼ÊÇÓ¢Ó

¿ªÊ¼Ð´Óʼþ£¬²»»áÍøÉÏËÑ. ¹«Ë¾ÓиöÓ¢ÓïרҵµÄ£¬Æ½Ê±¾ÍÊǰïÖúÎÒÃÇÌá¸ßÓ¢Óï¡£

ºóÀ´Óе㼼ÊõÁË£¬¾Í×Ô¼º¸É»îÁË¡£Óöµ½ÎÊÌâÀϰåÒ²²»ºÍÎÒÃǽ²(ËäÈ»Àϰå¸ãÁË20ÄêORACLE)¡£ ¹«Ë¾ÓÐmetalinkÕʺţ¬ÀϰåÈÃÎÒÕÒORACLEµÄ¹¤³Ìʦ£¬µç»°À´µç»°È¥£¬ÕæÌý²»¶®½²Ê²Ã´£¬¸ü²»ÓÃ̸¿ª¿Ú˵ÁË£¬ÄãÒª°ÑÄãµÄÎÊÌâÃèÊöÇå³þ£¬»¹ÒªÌýËûÃÇ˵£¬¶øÇÒ»¹Óкܶ๤³ÌʦÊÇÓ¡¶ÈµÄ£¬ÄÇÓ¢Ó


Ïà¹ØÎÊ´ð£º

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

½èˮԴÈËÆø£¡oracle jobÎÊÌ⣡ÔÚÏßµÈ

ÎÒдµÄÒ»¸öJob
declare
  job1 integer;
begin
  dbms_job.submit(job1,
    'Sale_FinanceUseFee(4,null,null,null);',
    TRUNC(SYSDATE)+1.103, ......

visual c#ÎÞ·¨Á¬½Óoracle£¿£¿£¿

´ó¼ÒºÃ£¬ÔÚ¿ª·¢µÄʱºò£¬Óöµ½ÕâÑùµÄÎÊÌ⣺

δÄܼÓÔØÎļþ»ò³ÌÐò¼¯¡°Oracle.DataAccess, Version=10.1.0.200, Culture=neutral, PublicKeyToken=89b483f429c47342¡±»òËüµÄijһ¸öÒÀÀµÏϵͳÕÒ²»µ½Ö¸¶¨µÄÎļþ¡£ ......

ÊÇoracleµÄbugô£¿É¢·ÖÁË£¡ - Oracle / »ù´¡ºÍ¹ÜÀí

±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
  set A.flag=1
  where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
  set A.flag=1
  where ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ