°Ù·ÖÓÐÇë¸ßÈËÖ¸µã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·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......
oracleÊý¾Ý¿âÓÐÄÄЩ¶ÔÏó
ÕâÎʵÃÌ«ÁýͳÁË,ÓÑÇé°ï¶¥.
ÕâÊÇÒ»¸ö´óÎÊÌ⣬ºÜ´óµÄÎÊÌâ¡£
°ï¶¥......
------------------------------------------------------------------------------
Blog£º http://b ......