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

Oracle 92ºÍOracle10gÏÂÔØµØÖ·

Oracle 9iÆóÒµ°æ¹Ù·½ÏÂÔØ9.2.0.1.0
¼òµ¥ÃèÊö£º oracleµÄ¹Ù·½ÍøÕ¾£ºwww.oracle.com ÕâÀïÓÐoracleµÄ¸÷ÖÖ°æ±¾µÄÊý¾Ý¿â¡¢Ó¦Óù¤¾ßºÍȨÍþµÄ¹Ù·½Îĵµ¡£Oracle9iÊÇÒµ½çµÚÒ»¸öÍêÕû¡¢¼òµ¥µÄÓÃÓÚ»¥ÁªÍøµÄÐÂÒ»´úÖÇÄÜ»¯µÄ¡¢Ð­×÷¸÷ÖÖÓ¦ÓõÄÈí¼þ»ù´¡¼Ü¹¹¡£ÏµÍ³ÒªÇó£ºÊÊÓÃÓ²¼þ»·¾³ ÖÁÉÙÐèÒª512MÄڴ棻½»»»Çø£ºÒ»°ãÒªÇóÊÇÄÚ´æµÄÁ½±¶£¬ÖÁÉÙÒªÇó´ïµ½400MÒÔÉÏ£»ÖÁÉÙÒªÓÐ2.5GBÒÔÉϵÄÊ£Óà¿Õ¼ä¡£
-------------------------------------------------------------------------------------------------------------------------------------
Oracle9iÏÂÔØµØÖ·£º
http://www.oracle.com/technology/software/products/oracle9i/htdocs/winsoft.html
-------------------------------------------------------------------------------------------------------------------------------------
Oracle¹Ù·½ÏÂÔØ£¬9.2.0.1.0¡£
http://download-west.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk1.zip
http://download-west.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk2.zip
http://download-west.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk3.zip
»òÕßÏÂÃæµØÖ·£º
http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk1.zip
http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk2.zip
http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk3.zip
-------------------------------------------------------------------------------------------------------------------------------------
Oracle10gÏÂÔØµØÖ·£º
http://www.oracle.com/technology/software/products/database/oracle10g/index.html


Ïà¹ØÎĵµ£º

ORACLE³£ÓÃSQLÓÅ»¯hintÓï¾ä

PowerBuilderÈ¡µÃ¾Þ´ó³É¾ÍµÄÔ­Òò¾ÍÊÇÓй¦ÄÜÇ¿´óºÍÁé»î¶à±äµÄDatawindow¶ÔÏ󣬱¾ÈËÓÃPowerBuilder¿ª·¢¹ýÒ»¶Îʱ¼äºó£¬×ܽá³öһЩ¼¼ÇÉ£¬ÒÔ¹©¹ã´óµÄPB¿ª·¢Õß½è¼øÊ¹Óá£
1¡¢ ÈçºÎ´´½¨Ò»¸ö¾ßÓÐÖð½¥µÝÔöÇóºÍ¹¦Äܵı¨±í£¬ÈçÏÂÐÎʽ£º Running TotalÁУ¬ÎÒÃÇ¿ÉʹÓüÆËãÁУºCumulativeSum£¨Quantity for all£©£¬¼´¿É´ïµ½Öð½¥µÝÔöÇóºÍ ......

ÔÚweblogic8.14ÀïÃæ²Ù×÷oracle´ó×Ö¶Î

1.Ê×ÏÈ˵Ã÷һϣº
Ô­ÒòÊÇÒòΪÎÒÔÚ×öÕâ¸öÏîĿʱ£¬±»ÏÞÖÆµÃÌ«¶à£¬weblogicºÍoracleµÄ°æ±¾²»Äܱ䣬ҪʹÓÃÔ­À´µÄ°æ±¾¡£
Òò´ËÄØ¡£²Ù×÷ÆðÀ´±È½ÏÂé·³¡£¶øÇÒ²»Äܸü¸ÄÔ­±¾¹¤³ÌÀïÃæµÄJar°ü£¨ËüÀïÃæ´æÔÚÁËoracle14.jar°ü£¬µ«±È½Ï¾É£©
weblogic°æ±¾Îª£º8.14
oracle°æ±¾Îª£º9i
2.ÔÚÕâÀïÄØ£¬Ê¹ÓÃhibernate£¬ÒÔÁ÷µÄÐÎʽ¶ÁÈ¡µ½Êý¾ÝÀïÃæ ......

OracleËæ»úÈ¡Êý¾ÝµÄ3ÖÖ·½Ê½

µÚÒ»ÖÖ£º
select * from SOME_TABLE sample(1) where rownum <= 10;
µÚ¶þÖÖ£º
select * from (select * from SOME_TABLE order by dbms_random.value) where rownum<=10;
µÚÈýÖÖ£º
select * from (select * from SOME_TABLE order by sys_guid()) where rownum <= 10; ......

Oracle±¸·ÝÓë»Ö¸´°¸Àý

Ò». Àí½âʲôÊÇÊý¾Ý¿â»Ö¸´
  µ±ÎÒÃÇʹÓÃÒ»¸öÊý¾Ý¿âʱ£¬×ÜÏ£ÍûÊý¾Ý¿âµÄÄÚÈÝÊǿɿ¿µÄ¡¢ÕýÈ·µÄ£¬µ«ÓÉÓÚ¼ÆËã»úϵͳµÄ¹ÊÕÏ£¨Ó²¼þ¹ÊÕÏ¡¢Èí¼þ¹ÊÕÏ¡¢ÍøÂç¹ÊÕÏ¡¢½ø³Ì¹ÊÕϺÍϵͳ¹ÊÕÏ£©Ó°ÏìÊý¾Ý¿âϵͳµÄ²Ù×÷£¬Ó°ÏìÊý¾Ý¿âÖÐÊý¾ÝµÄÕýÈ·ÐÔ£¬ÉõÖÁÆÆ»µÊý¾Ý¿â£¬Ê¹Êý¾Ý¿âÖÐÈ«²¿»ò²¿·ÖÊý¾Ý¶ªÊ§¡£Òò´Ëµ±·¢ÉúÉÏÊö¹ÊÕϺó£¬Ï£ÍûÄÜÖØ¹¹Õâ¸öÍêÕ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ