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

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......

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

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

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

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

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


°ï¶¥......
------------------------------------------------------------------------------ 
Blog£º http://b ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ