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È»ºó¿´¿´ÊÇʲôʱºòɾ³ýµÄÕâ¸ö¼Ç¼¡£
Ïà¹ØÎÊ´ð£º
ÎÒдµÄÒ»¸öJob declare job1 integer; begin dbms_job.submit(job1, 'Sale_FinanceUseFee(4,null,null,null);', TRUNC(SYSDATE)+1.103, ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿ ¸½Í¼Æ¬ ......
oracleÁ¬½ÓɶÕâô¸´ÔÓ°¡. oracle 10g ÓÃps/sql devÔõôҲÁ¬²»ÉÏ. ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË. listener.ora: SID_LIST_LISTENER = (SID_LIST = ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°Ñ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 ......