±¾ÈËϵͳWIN7
Ìý˵ ¿ÉÒÔ×°Oracle10.2.1 ºÍ11
²»ÄÜ×°Oracle9i
Çó¸öÏÂÔØËÙ¶È¿ìµãµÄOracle10.2.1ºÍ11 µÄÁ´½Ó
ллÁË £¨Ö±½ÓÒªÁ¬½Ó£©
sf ²»Áô ºÇºÇ
ÎÒÓÐ10.2µÄ°²×°³ÌÐò£¬ÒªµÄ»°¸øÄã·¢¹ýÈ¥
ÒýÓà ÎÒÓÐ10.2µÄ°²×°³ÌÐò£¬ÒªµÄ»°¸øÄã·¢¹ýÈ¥ ºÜ´óµÄ°É
ÒýÓà http://www.oracle.com/technology/global/cn/software/products/database/oracle10g/index.html Õâ¸öÎÒÕÒµ½¹ý ËٶȺÃÏñºÜÂýŶ
ÒýÓà oracle9iÎÒÓÐ,10gûÓÐ. 9i WIN7×°²»ÁË¡£¡£¡£´óÎÚ¹ê
ÒýÓà ÒýÓà 4 Â¥ tianxiaocui2007 µÄ»Ø¸´: ÎÒÓÐ10.2µÄ°²×°³ÌÐò£¬ÒªµÄ»°¸øÄã·¢¹ýÈ¥ ºÜ´óµÄ°É 1.11G£¬Ñ¹ËõǰµÄ
¹ÙÍøÏºÃÁË£¬ËÙ¶È»¹³É
ÒýÓà ÒýÓà 5 Â¥ feixianxxx µÄ»Ø¸´: ÒýÓà 4 Â¥ tianxiaocui2007 µÄ»Ø¸´: ÎÒÓÐ10.2µÄ°²×°³ÌÐò£¬ÒªµÄ»°¸øÄã·¢¹ýÈ¥ ºÜ´óµÄ°É 1.11G£¬Ñ¹ËõǰµÄ ¡£¡£Ñ¹ËõºóÄØ¡£¡£¡£
ÄѵÀÓÃQ´«£¿
ÒýÓà ¹ÙÍøÏºÃÁË£¬ËÙ¶È»¹³É ÎÒÔõôÊÇûËÙ¶È~
ѹËõºó1.04g
Âò¸öÅÌ×°°É
°²×°ÎļþÌ«´óÁË
ÎÒÓиö10gµÄ£¬Ñ¹Ëõºó620 MB
¶¥~~~~~~~ÎÒÓÐ10g
ÏÂÔØvista°æµÄ10.2g»òÕß11g
ÒýÓÃ
Ïà¹ØÎÊ´ð£º
ÎÒ°²×°Ò»Ì¨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£¨£© ......
ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......
select sname,(2009-10-05)-birth from student; birth×Ö¶ÎÖдæµÄÊdzöÉúÄêÔ£¬Ïë²éѯ³öÀ´µÄ½á¹ûÊÇÄêÁ䣬¸ÃÈçºÎ²éѯ£¿ ¼ÓÉÏdatediffº¯ÊýÊÔÊÔ select sname, to_char(sysdate,'YYYY')- to_char( ......