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

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°æ±¾µÄÆóÒµ¹ÜÀíÆ÷ÁË£¬²»¹ý²»ÂÛÄÇÒ»ÖÖ£¬ËûµÄ¿ÉÊÓ»¯²Ù×÷ÐÔ¶¼Ã»ÓÐ΢Èíɵ¹Ïʽ²Ù×÷ÄÇô·½±ãÁË£¬Ò»°ã±È½Ï·½±ã


Ïà¹ØÎÊ´ð£º

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......

oracleµÄ°²×°ºÍʹÓúÃÄÑ°¡ - Java / Java EE

oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿Ô­À´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......

javaºÍoracle - °¤ÌßÖ°ÑÄ / ²ÅÈëÖ°³¡

±¾ÈËÏÖÔÚѧoracle ËãÊǸոÕÈëÒ»°ëÃÅ ÒÔºó»¹ÒªÑ§java ¸÷λ´óÏÀoracleºÃÈëÊÖ»¹ÊÇjavaºÃÈëÊÖ°¡ ÒÔºóÄǸö·½Ãæ·¢Õ¹»áºÃЩ
£¬ÎÒÔÝʱÓиöÏë·¨ÏëºÃºÃѧϰһÏÂÊý¾Ý¿âÒÔºóÍùÕâ·½±ã·¢Õ¹£¬±Ï¾¹Êý¾Ý¿â¸úл»´úûÓÐjavaÄÇô¿ì£¬²» ......

oracle֪ʶ - Oracle / »ù´¡ºÍ¹ÜÀí

ÔÚOracle Êý¾Ý¿âÖÐÔõô²éÇ°ÈýÌõ¼Ç¼½µÐò£»
select * from
  (select * from table order by col_name desc)
where rownum<=3;

select * from
(
select s.*,rownum rn 
from t3 s
)
where ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ