lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
Ïà¹ØÎÊ´ð£º
ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬
-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......
»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
ÈÕÇ°ÓÃociº¯Êý²éѯoracleÊý¾Ýʱ³öÏÖ¸öÎÊÌ⣬¾ÍÊÇÔÚ²éѯµ½dateÀàÐ͵ÄÊý¾Ýʱ£¬Ê¹ÓÃpl/sql ²éѯoracle¿âÖеÄÊý¾ÝÏÔʾÊÇ
2009-9-29 12:12:12
µ«ÊÇͨ¹ýÓï¾äselect * from tablename ²éѯ£¬Ê¹ÓÃoci_fetch_array£¨£© ......
ÇëÎÊoracleÖн¨Á¢ÁÙʱ±í¿Õ¼äʱ£¬temp.dbfÕâ¸öÎļþÊÇÊÂÏÈ´æÔڵĻ¹ÊÇÔËÐÐÍêÏÂÃæµÄSQL¾Í»á×Ô¶¯´´½¨£¿Èç¹ûÊÇÊÂÏÈ´æÔڵģ¬ÄÇÊÇʲôÎļþ¸ñʽÄØ£¿ÈçºÎÕÒµ½£¿Ð»Ð»£¡
alter tablespace temp add tempfile ¡®/tstora/oradat ......
MSSQL2000 to Oracle 10g, text×Ö¶ÎÔõô´¦Àí£¿
ÓÃdtsµ¼Èë\µ¼³ö¹¤¾ß£¿
ѧϰ°ï¶¥²ä·Ö
sql server ÖÐµÄ±íµ¼µ½oracleÖУ¬ÔÚoracleÖжÔÓ¦textµÄÊý¾ÝÀàÐÍÊÇclobÀàÐÍ¡£
ÀûÓÃsqlserverµÄµ¼Èëµ¼³ö¹¦ÄÜ
× ......