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
Ïà¹ØÎĵµ£º
PowerBuilderÈ¡µÃ¾Þ´ó³É¾ÍµÄÔÒò¾ÍÊÇÓй¦ÄÜÇ¿´óºÍÁé»î¶à±äµÄDatawindow¶ÔÏ󣬱¾ÈËÓÃPowerBuilder¿ª·¢¹ýÒ»¶Îʱ¼äºó£¬×ܽá³öһЩ¼¼ÇÉ£¬ÒÔ¹©¹ã´óµÄPB¿ª·¢Õß½è¼øÊ¹Óá£
1¡¢ ÈçºÎ´´½¨Ò»¸ö¾ßÓÐÖð½¥µÝÔöÇóºÍ¹¦Äܵı¨±í£¬ÈçÏÂÐÎʽ£º Running TotalÁУ¬ÎÒÃÇ¿ÉʹÓüÆËãÁУºCumulativeSum£¨Quantity for all£©£¬¼´¿É´ïµ½Öð½¥µÝÔöÇóºÍ ......
1.Ê×ÏÈ˵Ã÷һϣº
ÔÒòÊÇÒòΪÎÒÔÚ×öÕâ¸öÏîĿʱ£¬±»ÏÞÖÆµÃÌ«¶à£¬weblogicºÍoracleµÄ°æ±¾²»Äܱ䣬ҪʹÓÃÔÀ´µÄ°æ±¾¡£
Òò´ËÄØ¡£²Ù×÷ÆðÀ´±È½ÏÂé·³¡£¶øÇÒ²»Äܸü¸ÄÔ±¾¹¤³ÌÀïÃæµÄJar°ü£¨ËüÀïÃæ´æÔÚÁËoracle14.jar°ü£¬µ«±È½Ï¾É£©
weblogic°æ±¾Îª£º8.14
oracle°æ±¾Îª£º9i
2.ÔÚÕâÀïÄØ£¬Ê¹ÓÃhibernate£¬ÒÔÁ÷µÄÐÎʽ¶ÁÈ¡µ½Êý¾ÝÀïÃæ ......
µÚÒ»ÖÖ£º
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; ......
Ò». Àí½âʲôÊÇÊý¾Ý¿â»Ö¸´
µ±ÎÒÃÇʹÓÃÒ»¸öÊý¾Ý¿âʱ£¬×ÜÏ£ÍûÊý¾Ý¿âµÄÄÚÈÝÊǿɿ¿µÄ¡¢ÕýÈ·µÄ£¬µ«ÓÉÓÚ¼ÆËã»úϵͳµÄ¹ÊÕÏ£¨Ó²¼þ¹ÊÕÏ¡¢Èí¼þ¹ÊÕÏ¡¢ÍøÂç¹ÊÕÏ¡¢½ø³Ì¹ÊÕϺÍϵͳ¹ÊÕÏ£©Ó°ÏìÊý¾Ý¿âϵͳµÄ²Ù×÷£¬Ó°ÏìÊý¾Ý¿âÖÐÊý¾ÝµÄÕýÈ·ÐÔ£¬ÉõÖÁÆÆ»µÊý¾Ý¿â£¬Ê¹Êý¾Ý¿âÖÐÈ«²¿»ò²¿·ÖÊý¾Ý¶ªÊ§¡£Òò´Ëµ±·¢ÉúÉÏÊö¹ÊÕϺó£¬Ï£ÍûÄÜÖØ¹¹Õâ¸öÍêÕ ......