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

´ò¿ªoracle 10g ÆóÒµ¹ÜÀíÆ÷

 ×°Á˸öOracle 10g£¬È´·¢ÏÖÕÒ²»µ½ÆóÒµ¹ÜÀíÆ÷ÁË¡£Ô­À´10gÓÖÉý¼¶Á˹ÜÀí¹¤¾ß£¬²»ÔÙ²ÉÓÃ8i, 9iµÄÄÇЩJava¹¤¾ßÁË£¬¶øÊÇÓëʱ¾ã½øµØ¸ÄÓÃÁËWeb·½Ê½¡£°´ÕÕÍøÉϵķ½·¨£ºhttp://»úÆ÷µÄIPµØÖ·:5500/em£¬»¹ÊÇûÓÐÁ¬ÉÏ¡£ÄѵÀ¶Ë¿ÚºÅ²»¶ÔÂð£¿
     ²é¿´Oracle 10g°²×°Ä¿Â¼installϵÄreadmeÎļþ£º
ÏÔʾ£º
Êý¾Ý¿âÅäÖÃÎļþÒѾ­°²×°µ½D:£¬Í¬Ê±ÆäËûÑ¡¶¨µÄ°²×°×é¼þÒ²ÒѾ­°²×°µ½ D:\oracle10g¡£
………
iSQL*Plus URL:
http://»úÆ÷Ãû:5560/isqlplus
Enteprise Manager 10g Database Control URL:
http://»úÆ÷Ãû:5500/em
http://»úÆ÷Ãû:5501/em
»»³Éhttp://»úÆ÷Ãû:5501/em¾ÍÄÜÁ¬ÉÏÁË:)¡£Äܹ»Á¬½ÓÉϵÄǰÌáÌõ¼þÊÇ£º·þÎñdbconsole±ØÐëÒѾ­Æô¶¯¡£
¿ªÊ¼ ÔËÐÐ cmd
set oracle_sid=Êý¾Ý¿âÃû
emctl start dbconsole
ÄÜ¿´µ½£º
Oracle Enterprise Manager 10g Database Control Release 10.1.0.2.0
Copyright (c) 1996, 2004 Oracle Corporation. All rights reserved.
http://»úÆ÷Ãû:5501/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ...OracleDBConsoleREDHERO
·þÎñÕýÔÚÆô¶¯ ..........................................
OracleDBConsoleREDHERO ·þÎñÒѾ­Æô¶¯³É¹¦¡£


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

ORACLEÁÙʱ±íºÍSQLSERVERÁÙʱ±íÒìͬ

 SQL SERVERÁÙʱ±í
Ò²¿ÉÒÔ´´½¨ÁÙʱ±í¡£ÁÙʱ±íÓëÓÀ¾Ã±íÏàËÆ£¬µ«ÁÙʱ±í´æ´¢ÔÚ tempdb ÖУ¬µ±²»ÔÙʹÓÃʱ»á×Ô¶¯É¾³ý¡£
Óб¾µØºÍÈ«¾ÖÁ½ÖÖÀàÐ͵ÄÁÙʱ±í£¬¶þÕßÔÚÃû³Æ¡¢¿É¼ûÐԺͿÉÓÃÐÔÉϾù²»Ïàͬ¡£±¾µØÁÙʱ±íµÄÃû³ÆÒÔµ¥¸öÊý×Ö·ûºÅ (#) ´òÍ·£»
ËüÃǽö¶Ôµ±Ç°µÄÓû§Á¬½ÓÊǿɼûµÄ£»µ±Óû§´Ó Microsoft? SQL Server? 2000 ʵÀý¶Ï ......

OracleÖеÄNullÖµ½âÎö

         ÓÐÈË×ܽáÁËÊý¾Ý¿âÖÐNullÖµµÄ¸ÅÄ±È½Ï¾«Á¶£¬ÕªÂ¼ÈçÏ£º
NullÊÇÊý¾Ý¿âÖÐÌØÓеÄÊý¾ÝÀàÐÍ£¬µ±Ò»Ìõ¼Ç¼µÄij¸öÁÐΪNull£¬Ôò±íʾÕâ¸öÁеÄÖµÊÇδ֪µÄ¡¢ÊDz»È·¶¨µÄ¡£¼ÈÈ»ÊÇδ֪µÄ£¬¾ÍÓÐÎÞÊýÖֵĿÉÄÜÐÔ¡£Òò´Ë£¬Null²¢²»ÊÇÒ»¸öÈ·¶¨µÄÖµ¡£
ÕâÊÇNullµÄÓÉÀ´¡¢Ò²ÊÇNullµÄ»ù´¡£¬ËùÓк ......

Oracle ±íÁ¬½Ó·½Ê½·ÖÎö

Ò» ÒýÑÔ
Êý¾Ý²Ö¿â¼¼ÊõÊÇĿǰÒÑÖªµÄ±È½Ï³ÉÊìºÍ±»¹ã·º²ÉÓõĽâ¾ö·½°¸£¬ÓÃÓÚÕûºÍµçÐÅÔËÓªÆóÒµÄÚ²¿ËùÓзÖÉ¢µÄԭʼҵÎñÊý¾Ý£¬²¢Í¨¹ý±ã½ÝÓÐЧµÄÊý¾Ý·ÃÎÊÊֶΣ¬¿ÉÒÔÖ§³ÖÆóÒµÄÚ²¿²»Í¬²¿ÃÅ£¬²»Í¬ÐèÇ󣬲»Í¬²ã´ÎµÄÓû§ËæÊ±»ñµÃ×Ô¼ºËùÐèµÄÐÅÏ¢¡£Êý¾Ý²Ö¿âϵͳÐèÒªÄܹ»¼°Ê±µØ×·×ٺͷÖÎö´óÁ¿µÄÀúÊ·Êý¾Ý£¬²¢Äܹ»¼°Ê±×ö³ö·ÖÎöºÍÔ¤²â£¬Òò´ËÊ ......

oracleÁÙʱ±íÏà¹ØÖªÊ¶

 ÔÚOracle8i»òÒÔÉϰ汾ÖУ¬¿ÉÒÔ´´½¨ÒÔÏÂÁ½ÖÖÁÙʱ±í£º
1¡£»á»°ÌØÓеÄÁÙʱ±í
    CREATE GLOBAL TEMPORARY <TABLE_NAME> (<column specification>)
    ON COMMIT PRESERVE ROWS£»
  
2¡£ÊÂÎñÌØÓеÄÁÙʱ±í
    CREATE GL ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ