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

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£¬·µ»ØÏàÓ¦ÐÅÏ¢


¶ÔÓÚÕâÑùÈ¡Êý£¬ÐÔÄܲ»ÊǺܺã¬ÊÇ·ñ¿ÉÒÔÓÅ»¯Ò»ÏÂÄØ
Ëû²éѯµÄʱºò¶¼ÊÇÈ«±íËÑË÷£¬Èç¹ûÑ­»·¶àÁË£¬ÐÔÄܾͻáÓÐÎÊÌâÁË
ºÎ¿öÎÒ»¹ÓÐÆäËûµÄÒµÎñÂß¼­£¬ÍâÃæ»¹ÓÐÑ­»·

ÄѵÀ´«ËµÖеĶ¯Ì¬¹æ»®£¿


Ïà¹ØÎÊ´ð£º

linux + oracleÓÃXP·ÃÎʲ»ÁË

ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬

-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......

ÇóʹÓÃt-sqlÓï¾ä½«paradoxÊý¾Ýµ¼ÈëoracleµÄ°ì·¨

ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......

¼±Ñ°Oracle ERPʵʩ¹ËÎÊ

3-5ÈË£¬¹¤×÷µØµãÉϺ£ÆÖ¶«Èí¼þÔ°£¬2-3Äê¾­Ñ飬ӢÎÄÁ÷Àû£¬ÓÐÒâÕßÇëÁªÏµ38954510-1355£¬15821699737£¬y.ming@live.cn
×Ô¼º¶¥¡£¡£¡£

ûÓÐORACLE ERPµÄ¾­Ñé,ÓÐÓÃÓѺÍTIPTOP¾­Ñé,Ó¢Óï˵²»ºÃ,¿´»¹ÊÇ¿ÉÒÔ!
²»ÖªµÀÓÐûÓÐ ......

Oracle¿Í»§¶Ë°²×°ºóODBCÎÞ·¨Ê¹ÓÃ

°²×°11gµÄ06,´ò²¹¶¡Éýµ½07£¬´ÓODBCÀïÃæ¿´£¬ÓÐ
Oracle in OraOdac11g_home1 11.01.00.07
´Ó×¢²á±í¿´HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ÏÂÃæµÄDriverºÍSetup¶¼ÊÇÎҵݲװ·¾¶
"D:\\app\\Ad ......

Çó½â MyEclipseÖÐÉèÖÃÁ¬½ÓOracle 10g³öÏÖµÄÎÊÌâ

ÈçÌâ¡£
¸ÕÔÚ×Ô¼ºµÄµçÄÔÀï°²×°ÀïOracle 10g
ÓÃMyEclipseÉèÖÃÁ¬½Ó£¬³öÏÖÈçÏ´íÎóÌáʾ£¬ÇëÎʸ÷λ¸ßÊÖÄÄÀï³öÁËÎÊÌ⣺¶àлָ½Ì£¡

Error while performing database login with the Oracle driver:
Io exc ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ