°Ù·ÖÓÐÇë¸ßÈËÖ¸µã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ÃüÁîÁË¡£¡£µÈ
Ïà¹ØÎÊ´ð£º
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
ÔÚOracle Êý¾Ý¿âÖÐÔõô²éǰÈýÌõ¼Ç¼½µÐò£»
select * from
(select * from table order by col_name desc)
where rownum<=3;
select * from
(
select s.*,rownum rn
from t3 s
)
where ......