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

°Ù·ÖÓÐÇë¸ßÈËÖ¸µãoracleÁ¬½ÓÎÊÌâ¡£

oracle 10g ÓÃsqlplus Á¬½Ó server  
 1.£¨¿Í»§¶ËºÍ·þÎñ¶ËÔÚһ̨»ú×ÓÉÏ£©
 ÇëÎÊ£¬ÔÚoracle 10gÁ¬½ÓµÄ¹ý³ÌÖÐ,ʹÓÃʲô·½Ê½Á¬½ÓµÄ£¨ÀýÈçodbc,jdbc»¹ÊÇĬÈϵĵײãÖ±½ÓµÄijij·½Ê½Á¬½ÓµÄ£©
 Èç¹ûÕâÊÇЩÖеÄij¸ö·½Ê½Á¬½ÓµÄ£¬ÇëÎÊÕâЩÁ¬½ÓµÄÅäÖÃÎļþÔÚÄÄÀï¡£ÊÇÔÚÄĸöÅäÖÃÎļþÖÐȥѡÔñ
 ÓÃʲôÑùµÄ·½Ê½Á¬½Ó£¿¡£¡£
 
 2.¿Í»§¶ËºÍ·þÎñ¶Ë²»ÔÚһ̨»ú×ÓÉÏ£©
  ÇëÎÊ£¬ÔÚoracle 10gÁ¬½ÓµÄ¹ý³ÌÖв»ÔÚһ̨»ú×ÓÉÏ£¬ËûÃǵÄÁ¬½ÓÓÐÄÄЩ·½Ê½£¿ 
 
 3.×îºóÒ»¸öÎÊÌ⣬ £¨¿Í»§¶ËºÍ·þÎñ¶ËÔÚһ̨»ú×ÓÉÏ£©
  ÎÒ²»ÓÃoracle×Ô´øµÄsqlplus¿ÉÒÔÁ¬½ÓserverÂð£¿ÓñðµÄ´°¿Ú£¬£¬£¨Çë²»ÒªÍÆ¼öÎÒÓý¨Á¢ÔÚsqlplusÉÏÃæµÄ¿ÉÊÓ»¯¹¤¾ß¡££©

tnsname.ora
רÓзþÎñÆ÷Á¬½Ó£¬¹²Ïí·þÎñÆ÷Á¬½Ó
sql developer

ÎÒÖªµÀµÄ£¬ÆÚ´ý¸ßÈË

1¡¢2£ºÓÃsqlplus Á¬½Ó server ,Ó¦¸Ã¾ÍÊÇÓõÄTCPͨÐÅЭÒé¡£ÅäÖÃÎļþÔÚlistener.oraÖУ¬¿ÉÒÔÓÃNet ManagerÅäÖÃÁ¬½Ó£¬ÕâºÍ¿Í»§¶ËÓë·þÎñÆ÷ÔÚ²»ÔÚÒ»ÆðûÓÐÊ²Ã´Çø±ð¡£Äã˵µÄodbc,jdbcÊÇÔÚ¿ª·¢Ó¦ÓóÌÐòµÄʱÁ¬½ÓÊý¾Ý¿âÓõ½µÄÖмäЭÒé¡£
3£º²»Ã÷°×Äã˵µÄ¡°½¨Á¢ÔÚsqlplusÉÏÃæµÄ¿ÉÊÓ»¯¹¤¾ß¡±ÊÇʲô¡£
pl/sql developer¡¢toad¡¢Oracle SQL Developer ...²»ÖªµÀÊDz»ÊÇÄãÏëÒªµÄ¡£¡£¡£¡£


²¹³äһϣ¬
±¾»úÁ¬½Ó: sqlplus <Óû§Ãû>/<ÃÜÂë>
Ô¶³ÌÁ¬½Ó£ºsqlplus <Óû§Ãû>/<ÃÜÂë>@<tnsnames.oraÖÐÅäÖõÄÁ¬½Ó´®Ãû>

Á¬½Ó×ܽ᣺http://www.itpub.net/thread-303970-1-1.html
³£¼ûÎÊÌ⣺http://www.cnblogs.com/markhe/archive/2009/06/04/1496452.html


ÄãÃÇÕ⻹ÊÇÓõ½ÁËsqlplusÃüÁîÁË¡£¡£µÈ


Ïà¹ØÎÊ´ð£º

Oracle Êý¾Ýµ¼³öÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

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

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

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ºÅ