Ãâ°²×°Oracle¿Í»§¶ËÈí¼þ ʹÓÃpl/sqlÅäÖõǽ
	
    
    
	ËäÈ»ÕâÊÇÎÒÕÒµ½×îÏêϸµÄÅäÖÃÃèÊö£¬µ«Êdz¢ÊÔ»¹ÊÇûÓгɹ¦¡£
 
1.ÏÂÔØOracle Client Package
 .
´Ó
http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html
ÏÂÔØ
Instant
 Client Package – Basic
°ü
(
 
±ê×¢
:All files
 required to run OCI, OCCI, and JDBC-OCI applications)
ÕâÀïÏÂÔØµÄÊÇ
Version 11.1.0.7
2.±¾µØ±£´æOracle Client 
Package:
´´
½¨Îļþ¼Ð
,
±ÈÈç
oracle_client,
½«
ÏÂÔØµÄÎļþ¼ÓѹËõµ½´ËÎļþ¼ÐÀï
.(
±ÊÕßĿ¼
:
 D:\oracle_client\instantclient_10_2)
3.
ÔÚµ±Ç°Ä¿Â¼ÏÂ
,н¨Á¢Á½¸öÎļþ£¬sqlnet.oraºÍtnsnames.oraÈ»ºóÔÙ
ÊÖ¶¯ÅäÖÃ
sqlnet.ora
ºÍ
tnsnames.ora
±ÈÈçÕâÀïÊÇ
:
sqlnet.ora
ÎļþÄÚÈÝ
:
SQLNET.AUTHENTICATION_SERVICES=
 (NTS)
NAMES.DIRECTORY_PATH=
 (TNSNAMES, EZCONNECT)
 
tnsnames.ora
ÎļþÄÚÈÝ
(
бÌå±íʾÐèÒªÌæ»»µÄÄÚÈÝ
):
orcl
=
(DESCRIPTION =
    
(ADDRESS_LIST
 =
      
(ADDRESS
 = (PROTOCOL = TCP)(HOST = 192.168.1.103
)(PORT = 
1521))
    
)
    
(CONNECT_DATA
 =
      
(SERVICE_NAME
 = orcl
)
    
)
)
 
4.
ÅäÖû·¾³±äÁ¿
±äÁ¿Ãû
:
 TNS_ADMIN
±äÁ¿Öµ
:
 
D:\oracle_client\instantclient_10_2
·ñÔò³öÏÖ
:ORA-12154: TNS:could not resolve
 the connect identifier specified´íÎó
 
 
Èç¹û֮ǰ
°²×°ÁË
Oracle 
ÓÖÐ¶ÔØ
,
»áÒÅÁô
NLS_LANG=NA
µÄ¼üÖµ
.
ÊäÈë
RegEdit
´ò¿ª×¢²á±í
HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE.
ÔÚÓÒÃæÕÒµ½
NLS_LANG=NA
²¢É¾³ýµô
·ñÔò»á±¨
ORA-12705:
 Cannot access NLS data files or invalid 
´íÎó
.
 
5.
°²×°
pl/sqlÈí¼þ(¹ý³ÌÂÔ)
6.ÅäÖÃpl/sqlµÄOracleÁ¬½Ó²ÎÊý:
Ñ¡Ôñ
pl/sql
µÄ¹¤¾ß
/
Ê×Ñ¡Ïî
(too/
 preference/
)
ÀïµÄÁ¬½Ó
,
ÔÚÓÒÃæÉèÖÃ
Oracle
Ö÷Ŀ¼Ãû
(
¼´°²×°Ä¿Â¼
)
ºÍ
OCI
¿â
.
Oracle
Ö÷Ŀ¼
Ãû
: 
D:\oracle_client\instantclient_10_2
OCI
¿â
: 
D:\oracle_client\instantclient_10_2\oci.dll
7.
怫
pl/sql
²âÊԳɹ¦
    
     
	
	
    
    
	Ïà¹ØÎĵµ£º
        
    
    Ò»¸öʹÓÃibatis¶ÔÊý¾Ý¿âÔöɾ¸Ä²éµÄÀý×Ó:
ÕâÀïÓõĿª·¢»·¾³ÊÇ:Eclipse3.2+mysql5.0.20,ibatis°üÊÇibatis-common-2.jar,
ibatis-dao-2.jar,ibatis-sqlmap-2.jar,mysql°üÊÇmysql-connector-java-5.0.3-bin.jar.
²½Öè:
1.´´½¨Êý¾Ý¿â:
 create database itcast;
 use itcast;
´´½¨±í£º
 create table stu ......
	
    
        
    
    insert into
    select * into t_dest from t_src; -- ÒªÇóÄ¿±ê±í²»´æÔÚ
    insert into t_dest(a, b) select a, b from t_src; -- ÒªÇóÄ¿±ê±íÒÑ´æÔÚ
¶¯Ì¬SQL
    execute immediate ......
	
    
        
    
    µ±±¾»ú°²×°ÁËORACLEÊý¾Ý¿âºó£¬ÔÙ°²×°ÔËÐÐOC4JµÄ»°£¬»·¾³±äÁ¿“ORACLE_HOME”ÓëORACLEÊý¾Ý¿âÓгåÍ»£¬¿ÉÒÔ°´ÕÕÈçÏ·½·¨½â¾ö´ËÎÊÌ⣺ 
·½·¨Ò»
µÚÒ»²½£ºÔÚ»·¾³±äÁ¿ÖÐн¨“OC4J_HOME”£¬Ö¸¶¨µ½ÄãµÄOC4J°²×°¸ùĿ¼£»
µÚ¶þ²½£º´ò¿ªOC4J°²×°µÄĿ¼£¬¼´../OC4J/bin/£¬ÀïÃæÓÐÒ»¸öoc4j.cmd£¬ÓÒ¼üµ¥»÷¸ÃÎļþ£¬Ñ ......
	
    
        
    
    ºó׺ÃûΪ.mdfµÄsqlÊý¾Ý¿âÈçºÎ´ò¿ª£¿
ÓÐ.mdfºÍ.ldfÁ½¸öÎļþ£¬´ò¿ª·½°¸£º
·½·¨Ò»£ºÔÚSql serverÆóÒµ¹ÜÀíÆ÷ÖÐ   -   Êý¾Ý¿â   - ÓÒ¼ü <¸½¼ÓÊý¾Ý¿â
 ·½·¨¶þ£ºÔÚVS2005ÖÐÏȽ¨Á¢Ò»¸öÓëÄãÒª´ò¿ªµÄmdfÎļþͬÃûµÄÊý¾Ý¿â£¬¼Çס´æ´¢Î»Öã¬È»ºóÓÃÄãÒª´ò¿ªµÄmdfÎļþ½«¸Õ½¨Á¢µÄmdfÊý¾Ý¿âÎļþÌæ»»¼´¿É¡£ ......
	
    
        
    
    ˼·:SQLÀᄀ¿ÉÄܵIJÉÓÃÁ½¸öÒýºÅ±ÕºÏ±äÁ¿;¶Ô±äÁ¿ÖеÄÒýºÅתÒå;¶Ô²»ÄܲÉÓÃ2¸öÒýºÅ±ÕºÏµÄ±äÁ¿,ÏÈÔ¤ÏÈÅжϱäÁ¿ÀàÐÍ;   
    
  ·½°¸:   
  1   ËùÓзÇÊýÖµÔËËã(Èç×Ö·û,¼òµ¥ÊýÖµÐ͵ȵÈ)µÄSQL±äÁ¿¶¼¼ÓÒýºÅ;   
  2   ËùÓзÇÊýÖµÔËËãµÄSQL±äÁ¿µÄÖµ¶¼²ÉÓÃmagic_quotes_gpc» ......