ORACLEËæ»ú¼Ç¼³éÈ¡
ÎÒÏÖÔÚÐèÒªËæ»ú³éÈ¡table±íµÄµÄÊý¾Ý£¬±íµÄÊý¾ÝÓÐ100Íò£¬table´æÔÚÒ»¸ö×Ö¶Îa ÒªÇó³éÈ¡³öÀ´µÄÊý¾Ýa×ֶεÄ×ܺÍÒªµÈÓÚ1000£¬ËÓкõķ½·¨£¬Çë½ÌÁË£¡
1Â¥ÒýÓõÄÎÄÕ£¬»á·ñÖØ¸´È¡ÏàͬµÄ¼Ç¼ºÅ£¿ ÀýÈ磺 id value 1 3 2 3 3 2 4 2 µÃ³öµÄ½á¹ûΪ1,1,3,3 ¶ø²»ÊÇ1,2,3,4ÕâÑùµÄ½á¹û not instr(v_str,','||id||',')>0 ËûÕâÀïÒѾ¹ýÂËÖØ¸´µÄÁË£¬²»»á³öÏÖÖØ¸´ID Ö»ÊÇÓÐÒ»µã£¬Èç¹û³ÌÐò´ò²»µ½ÏëÒªµÄ½á¹û£¬³ÌÐò»á½øÈëÎÞÏÞÑ»·£¬ÕâµãÓеãÍ·Í´ ÇëÎÊÓнâ¾ö·½·¨Ã»ÓУ¿£¿ ¼Ó¸ö²ÎÊý ³õֵΪ1£¬Ã¿½øÐÐÒ»´ÎÑ»·ÔòÔö¼Ó1 µ±´ïµ½Ò»¶¨ÊýÖµµÄʱºò»¹ÔÚ½øÐÐÑ»·£¬return£¬·µ»ØÏàÓ¦ÐÅÏ¢ÒýÓà ¼Ó¸ö²ÎÊý ³õֵΪ1£¬Ã¿½øÐÐÒ»´ÎÑ»·ÔòÔö¼Ó1 µ±´ïµ½Ò»¶¨ÊýÖµµÄʱºò»¹ÔÚ½øÐÐÑ»·£¬return£¬·µ»ØÏàÓ¦ÐÅÏ¢ ¶ÔÓÚÕâÑùÈ¡Êý£¬ÐÔÄܲ»ÊǺܺã¬ÊÇ·ñ¿ÉÒÔÓÅ»¯Ò»ÏÂÄØ Ëû²éѯµÄʱºò¶¼ÊÇÈ«±íËÑË÷£¬Èç¹ûÑ»·¶àÁË£¬ÐÔÄܾͻáÓÐÎÊÌâÁË ºÎ¿öÎÒ»¹ÓÐÆäËûµÄÒµÎñÂß¼£¬ÍâÃæ»¹ÓÐÑ»· ÄѵÀ´«ËµÖеĶ¯Ì¬¹æ»®£¿
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£ ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É л ......
ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......
°²×°11gµÄ06,´ò²¹¶¡Éýµ½07£¬´ÓODBCÀïÃæ¿´£¬ÓÐ Oracle in OraOdac11g_home1 11.01.00.07 ´Ó×¢²á±í¿´HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ÏÂÃæµÄDriverºÍSetup¶¼ÊÇÎҵݲװ·¾¶ "D:\\app\\Ad ......
ÎÒдµÄÒ»¸öJob declare job1 integer; begin dbms_job.submit(job1, 'Sale_FinanceUseFee(4,null,null,null);', TRUNC(SYSDATE)+1.103, ......
Êý¾Ý±Ãµ¼È뱨ÈçÏ´íÎóORA-39016 ²»ÖªµÀÊÇʲôÔÒò,ÇëÖ¸½Ì.... лл' Processing object type TABLE_EXPORT/TABLE/TABLE_DATA ORA-39016: Operation not supported when job is in EXECUTING ......