ÇëÎÊΪʲôOracle¼àÌýºó»áÓдóÁ¿µÄµÈ´ýÁ¬½Ó£¿
ÏÂÃæÊǸոÕÖØÆôºóÔËÐÐnetstatµÄ½á¹û£¬ÕªÂ¼ÁËÆäÖÐÓë1521¶Ë¿ÚÓйصIJ¿·Ö
TCP tky-026e3e945e8:1055 localhost:1521 ESTABLISHED
TCP tky-026e3e945e8:1057 localhost:1521 TIME_WAIT
TCP tky-026e3e945e8:1060 localhost:1521 TIME_WAIT
TCP tky-026e3e945e8:1061 localhost:1521 TIME_WAIT
TCP tky-026e3e945e8:1062 localhost:1521 TIME_WAIT
TCP tky-026e3e945e8:1063 localhost:1521 TIME_WAIT
TCP tky-026e3e945e8:1064 localhost:1158 TIME_WAIT
TCP tky-026e3e945e8:1065 localhost:1521 TIME_WAIT
TCP tky-026e3e945e8:1066 localhost:1521 TIME_WAIT
TCP tky-026e3e945e8:1068 localhost:1521 TIME_WAIT
TCP tky-026e3e945e8:1069 localhost:1521 TIME_WAIT
TCP tky-026e3e945e8:1070 localhost:1521 TIME_WAIT
TCP tky-026e3e945e8:1071 localhost:1521
Ïà¹ØÎÊ´ð£º
ÈÕǰÓÃociº¯Êý²éѯoracleÊý¾Ýʱ³öÏÖ¸öÎÊÌ⣬¾ÍÊÇÔÚ²éѯµ½dateÀàÐ͵ÄÊý¾Ýʱ£¬Ê¹ÓÃpl/sql ²éѯoracle¿âÖеÄÊý¾ÝÏÔʾÊÇ
2009-9-29 12:12:12
µ«ÊÇͨ¹ýÓï¾äselect * from tablename ²éѯ£¬Ê¹ÓÃoci_fetch_array£¨£© ......
ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......
oracle not available
shared memory realm does not exist
ÇëÎʸßÊÖÕâ¸öÎÊÌâÈçºÎ½â¾ö£¿
http://www.inthirties.com/thread-109-2-1.html
Ö¸¶¨ÏÂORACLE_SID,ORACLE_HOME¿´¿´£¬²»ÐоÍÓÃ1Â¥µÃ·½·¨ÁË..
cm ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
......
Ôõô½«·ûºÅµ¥ÒýºÅ²åÈëORACLEÊý¾Ý¿âµÄ±íÖÐÈ¥°¡£¿
лл¸÷λ.
SQL code:
SQL> insert into test values('''');
ÒÑ´´½¨ 1 ÐС£
SQL> select * from test;
ID
----------
'
¿ÉÒÔÓÃÁ½¸öµ¥ÒýºÅÀ´±íʾ ......