oracle odbcÁ¬½ÓÎÊÌâ
ÎÒÔÚʹÓÃodbcÊý¾ÝÔ´µÄʱºò£¬ÎÒµÄÊý¾ÝÔ´ÏÔʾΪoracle in oraDB10g_home1
¶øÔÚµã»÷Ìí¼ÓʱÏÔʾµÄȴΪoracle in oraDB10g_home3
Ë«»÷Êý¾ÝԴʱ±¨´í£¬ÕÒ²»µ½oracleµÄÇý¶¯
ËÄܰïÖú½â¾öһϣ¡£¡£¡£¡
лл
Äã°²×°Á˶à´Îoracle?
Ö»ÓÐÑ¡ÔñÊý¾ÝÔ´Çý¶¯Ê±ÏÔʾ
»¹ÓÐÄĶùÏÔʾ£¿
µ½ÍøÉϵ´¸öoracleÇý¶¯°ü ¼ÓÔØµ½³ÌÐòÖÐ
È¥×¢²á±í°ÑÒÔǰ°²×°ÒÅÁôÏÂÀ´µÄ¶«Î÷ɾµôÓ¦¸Ã¿ÉÒÔ
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......