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

oracleµÄchange notificationÎÊÌâ

±¾ÈËʹÓÃOCIµÄ½Ó¿ÚÏòÊý¾Ý¿â×¢²áÁËÒ»¸ö²éѯselect * from test_tab£¬
²é¿´ user_change_notification_regsʱ£¬¿ÉÒÔ¿´µ½Õâ¸ö¶«Î÷£¬
µ«ÊÇÏò±ítest_tab²åÈëÊý¾Ý²¢Ìá½»ºó£¬Õâ¸ö×¢²á¾ÍÏûʧÁË£¨ user_change_notification_regsÀïÃæµÄ¼Ç¼ÏûʧÁË£©£¬
ҲûÓнøÈëÓ¦ÓóÌÐòµÄ»Øµ÷º¯Êý£¬

ÓÐûÓÐÈËÓöµ½¹ýÕâÖÖÇé¿ö°¡£¿

ÎÒÊÔ¹ý¼¸¸öÊý¾Ý¿â£¬Óеijɹ¦£¬ÓеÄʧ°Ü£¬µ«ÊDz鿴Êý¾Ý¿âµÄÅäÖÃÒ²²î²»¶à¡£

¶øÇÒÔÚÒ»¸öÊý¾Ý¿âÀïÃæ£¬ÒÔǰÊÇ¿ÉÒԵģ¬×î½üÓÖ²»ÐÐÁË£¬À§»ó°¡¡£¡£¡£
¼ì²éÒ»ÏÂÓÐûÓÐtrigger»ùÓÚÕâ¸ötest_tab±íµÄ

ûÓÐÍÛ£¬¶¼ÊÇÎÒÁÙʱн¨µÄ±í¡£

¶¥Ï£¬Ã»ÈËÓöµ½¹ýÕâÖÖÎÊÌâÂð£¿

ûÓöµ½¹ý£¬°ï¶¥

ÓÑÇé°ï¶¥

¶¥¶¥¶¥°¡

¶¥

ÒýÓÃ
±¾ÈËʹÓÃOCIµÄ½Ó¿ÚÏòÊý¾Ý¿â×¢²áÁËÒ»¸ö²éѯselect * from test_tab£¬
²é¿´ user_change_notification_regsʱ£¬¿ÉÒÔ¿´µ½Õâ¸ö¶«Î÷£¬
µ«ÊÇÏò±ítest_tab²åÈëÊý¾Ý²¢Ìá½»ºó£¬Õâ¸ö×¢²á¾ÍÏûʧÁË£¨ user_change_notification_regsÀïÃæµÄ¼Ç¼ÏûʧÁË£©£¬
ҲûÓнøÈëÓ¦ÓóÌÐòµÄ»Øµ÷º¯Êý£¬

ÓÐûÓÐÈËÓöµ½¹ýÕâÖÖÇé¿ö°¡£¿

ÎÒÊÔ¹ý¼¸¸öÊý¾Ý¿â£¬Óеijɹ¦£¬ÓеÄʧ°Ü£¬µ«ÊDz鿴Êý¾Ý¿âµÄÅäÖÃÒ²²î²»¶à¡£

¶øÇÒÔÚÒ»¸öÊý¾Ý¿âÀïÃæ£¬ÒÔǰÊÇ¿ÉÒԵģ¬×î½üÓÖ²»ÐÐÁË£¬À§»ó°¡¡£¡£¡£


Õâ¸öÌ«Ææ¹ÖÁË¡£

×÷¸ösql traceÈ»ºó¿´¿´ÊÇʲôʱºòɾ³ýµÄÕâ¸ö¼Ç¼¡£


Ïà¹ØÎÊ´ð£º

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

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

¹òÇó lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ

ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
¸½Í¼Æ¬ ......

oracleÈëÃÅÅäÖÃ

oracleÁ¬½ÓɶÕâô¸´ÔÓ°¡.
oracle 10g
ÓÃps/sql devÔõôҲÁ¬²»ÉÏ.
ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË.
listener.ora:
SID_LIST_LISTENER =
  (SID_LIST =
  ......

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

oracleÈçºÎʵÏÖ´ø²ÎÊýµÄ·ÖÒ³²éѯ

ÇëÎÊÔÚoracleÖÐÈçºÎʵÏÖЧ¹û¾ÍÏñÔÚSQL ServerÖÐ"select top " + pageSize + " * from tb_user where id not in (select top " + curPage*pageSize + " id from tb_user) and units_id=1&qu ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ