Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ......

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

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

oracleÊý¾Ý¿âÓÐÄÄЩ¶ÔÏó
ÕâÎʵÃÌ«ÁýͳÁË,ÓÑÇé°ï¶¥.

ÕâÊÇÒ»¸ö´óÎÊÌ⣬ºÜ´óµÄÎÊÌâ¡£


°ï¶¥......
------------------------------------------------------------------------------ 
Blog£º http://b ......

oracleÊý¾Ý¿â - Oracle / ¸ß¼¶¼¼Êõ

ÔÚOracleÖÐÔõôɾ³ýÖØ¸´µÄÐУ¬µ«Òª±£ÁôÒ»Ìõ¼Ç¼¡£

delete table where rowid not in (select max(rowid) from table group by col1,col2,...,coln);

¶Ô£¬ÓÃrowid À´¹ýÂË.

delete tb a
where a.rowid > ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ