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

¡¾ÇóORACLE°æ±¾ÏÂÔØ¡¿

±¾ÈËϵͳ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

ÒýÓÃ


Ïà¹ØÎÊ´ð£º

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

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

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

OracleÅúÁ¿²åÈëÒ»ÄêÖÜÆÚÊý¾Ý

ÎÒÏëÔÚÊý¾Ý±íÖвåÈëһЩÈÕÆÚÊý¾Ý¡£·Ö±ðÓÐyear week start_date end_date ¶¼´ú±í×ÅÊÇʲôÄê·Ý¡£ÔÚÕâÒ»ÄêÀïµÄµÚ¼¸¸öÖÜÆÚ¡£¿ªÊ¼Ê±¼äÊǼ¸Ô¼¸ºÅ µ½¼¸Ô¼¸ºÅ£¨Àý£º2009 1 2008-12-28 2009-1-3£©ÒòΪҪ²åÈëÒ»ÄêµÄÊý¾ÝÈç¹ûÒ ......

[ÇóÖú] oracleÎÞ·¨Æô¶¯

·þÎñÆ÷ϵ缸Ììºó½ñÌìÉϵ磬Êý¾Ý¿âÈ´ÔõôҲÆð²»ÁËÁË£¬¾ßÌåÇé¿öÈçÏ£º

SQL> startup
ORACLE instance started.

Total System Global Area 5010685952 bytes
Fixed Size      & ......

oracleÖÐÓɳöÉúÄêÔ»ñµÃÄêÁä

select sname,(2009-10-05)-birth
from student;

birth×Ö¶ÎÖдæµÄÊdzöÉúÄêÔ£¬Ïë²éѯ³öÀ´µÄ½á¹ûÊÇÄêÁ䣬¸ÃÈçºÎ²éѯ£¿
¼ÓÉÏdatediffº¯ÊýÊÔÊÔ

select sname, to_char(sysdate,'YYYY')- to_char( ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ