oracle ¿ÉÊÓ»¯¿´±íÄÚÈÝ - Oracle / »ù´¡ºÍ¹ÜÀí
ÎÒ°²×°ÁËoracle 10g¾¹ýÒ»·¬Å¬Á¦Äܹ»Ë³ÀûµÄÁ¬½ÓÉÏÁË£¬ µ«ÊÇÎÒÒÔÇ°ÓõÄÊÇsql server ËûµÄÆóÒµ¹ÜÀíÆ÷ÖÐÄܶԱí½øÐпÉÊÓ»¯¹ÜÀí ÔÚoracleÖÐÎÒÒ²¿´µ½ÁËÓпÉÊÓ»¯µÄem µ«ÊÇÎÒ¾ÍÊÇ¿´²»µ½±íµÄÄÚÈÝÀ´ ÇëÎÊÓÐûÓдóϺÄÜ°ï°ïæ!
µ«ÊÇÎÒ¾ÍÊÇ¿´²»µ½±íµÄÄÚÈÝÀ´ SELECT ¾Í³öÀ´ÁË£¬¡£¡£¡£¡£¡£¡£ »¹ÊǵÃÓÃsqlplusÂ𣿠³õѧÕߣ¬»¹ÊÇ×°Ò»¸öµÚÈý·½¹¤¾ß°É£¬pl/sql developer ÈÝÒ×ÉÏÊÖ£¬¸üÏósql serverµÄÆóÒµ¹ÜÀíÆ÷ pl/sql developer¸úToad£¬Á½¸ö¶¼ºÜÁ÷ÐÐ ×°¸ö11g Ò²¿ÉÒÔ, ÀïÃæÓиö sqldevelop ÄãÒª¿´±íÄÚÈÝ£¬ÈçÉÏËù˵£ºSELECTһϲ»¾Í³öÀ´ÁËô£¬ºÇºÇ£¬ÆäʵORACLE 9IÒ²ÓÐÒ»¸ö±¾µØµÄÆóÒµ¹ÜÀíÆ÷£¬ORACLE 10Gºó¾ÍÈ«ÊÇWEB°æ±¾µÄÆóÒµ¹ÜÀíÆ÷ÁË£¬²»¹ý²»ÂÛÄÇÒ»ÖÖ£¬ËûµÄ¿ÉÊÓ»¯²Ù×÷ÐÔ¶¼Ã»ÓÐ΢Èíɵ¹Ïʽ²Ù×÷ÄÇô·½±ãÁË£¬Ò»°ã±È½Ï·½±ãµÄ²Ù×÷¶¼ÊÇÓõÚÈý·½µÄPL/SQL(Ãâ·Ñ)»òÕßToad£¨ÓаæȨ£©¡£²»¹ýÓÉÓÚORACLE±¾ÉíÄÚ²¿¶«Î÷·Ç³£¶à£¬ËùÒÔÕâЩµÚÈý·½Ö»ÊÇÌṩÁËһЩ³£ÓõÄÅäÖÃÐÅÏ¢£¬¸ü¶à¸üÉîÈëµÄ¶«Î÷»¹ÊÇÒªÓÃORACLEÌṩµÄsqlplus»òÕßsqlplusw¹¤¾ß¡£²»¹ýÒ»°ã¶ÔÓ¦»ù±¾¿ª·¢£¬³£ÓõÄÒѾ×ã¹»ÁË£»ÌØÊâµÄÎÒ¼òµ¥¾ÙÁ½¸öÀý×Ó£ºÈç·ÖÇø±í»òÕßcacheÒÔ¼°´æ´¢Î»ÖÃÉèÖÃÐÅÏ¢£¬Ö±½ÓÓÃPL/SQL±à¼±í²é¿´Ô´ÂëÊÇ¿´²»µ½µÄ£»ÁíÍâÈçÖ´ÐÐORACLE_HOME/RDBMS/ADMIN/ ÏÂÃæµÄÀ©Õ¹°ü£¨È磺SYS.DBMS_SHARED_POOLÓÃÓÚ½«¶ÔÏóKEEPµ½¹²Ïí³ØµÄ°ü£©£¬ÕâЩ°üÓõÚÈý·½µÄ¹¤¾ßÀ´Ö´ÐÐÍùÍù²»ºÃÓã¬ÐèÒªµ½SQLPLUSÏÂÈ¥Ö´ÐвÅÄܳɹ¦¡£ÒýÓà ÄãÒª¿´±íÄÚÈÝ£¬ÈçÉÏËù˵£ºSELECTһϲ»¾Í³öÀ´ÁËô£¬ºÇºÇ£¬ÆäʵORACLE 9IÒ²ÓÐÒ»¸ö±¾µØµÄÆóÒµ¹ÜÀíÆ÷£¬ORACLE 10Gºó¾ÍÈ«ÊÇWEB°æ±¾µÄÆóÒµ¹ÜÀíÆ÷ÁË£¬²»¹ý²»ÂÛÄÇÒ»ÖÖ£¬ËûµÄ¿ÉÊÓ»¯²Ù×÷ÐÔ¶¼Ã»ÓÐ΢Èíɵ¹Ïʽ²Ù×÷ÄÇô·½±ãÁË£¬Ò»°ã±È½Ï·½±ã
Ïà¹ØÎÊ´ð£º
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......
±¾ÈËÏÖÔÚѧoracle ËãÊǸոÕÈëÒ»°ëÃÅ ÒÔºó»¹ÒªÑ§java ¸÷λ´óÏÀoracleºÃÈëÊÖ»¹ÊÇjavaºÃÈëÊÖ°¡ ÒÔºóÄǸö·½Ãæ·¢Õ¹»áºÃЩ £¬ÎÒÔÝʱÓиöÏë·¨ÏëºÃºÃѧϰһÏÂÊý¾Ý¿âÒÔºóÍùÕâ·½±ã·¢Õ¹£¬±Ï¾¹Êý¾Ý¿â¸úл»´úûÓÐjavaÄÇô¿ì£¬²» ......
ÔÚOracle Êý¾Ý¿âÖÐÔõô²éÇ°ÈýÌõ¼Ç¼½µÐò£» select * from (select * from table order by col_name desc) where rownum<=3; select * from ( select s.*,rownum rn from t3 s ) where ......