±¾ÈËϵͳ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
ÒýÓÃ
Ïà¹ØÎÊ´ð£º
ÎÒ¶Ô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ʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......
ÎÒÏëÔÚÊý¾Ý±íÖвåÈëһЩÈÕÆÚÊý¾Ý¡£·Ö±ðÓÐyear week start_date end_date ¶¼´ú±í×ÅÊÇʲôÄê·Ý¡£ÔÚÕâÒ»ÄêÀïµÄµÚ¼¸¸öÖÜÆÚ¡£¿ªÊ¼Ê±¼äÊǼ¸Ô¼¸ºÅ µ½¼¸Ô¼¸ºÅ£¨Àý£º2009 1 2008-12-28 2009-1-3£©ÒòΪҪ²åÈëÒ»ÄêµÄÊý¾ÝÈç¹ûÒ ......
·þÎñÆ÷ϵ缸Ììºó½ñÌìÉϵ磬Êý¾Ý¿âÈ´ÔõôҲÆð²»ÁËÁË£¬¾ßÌåÇé¿öÈçÏ£º SQL> startup ORACLE instance started. Total System Global Area 5010685952 bytes Fixed Size & ......
select sname,(2009-10-05)-birth from student; birth×Ö¶ÎÖдæµÄÊdzöÉúÄêÔ£¬Ïë²éѯ³öÀ´µÄ½á¹ûÊÇÄêÁ䣬¸ÃÈçºÎ²éѯ£¿ ¼ÓÉÏdatediffº¯ÊýÊÔÊÔ select sname, to_char(sysdate,'YYYY')- to_char( ......