oracleѧϰÊé¼®ÍÆ¼ö
ÏÖÔÚ¶ÔoracleµÄÌåϵ½á¹¹ÓÐÁË´ó¸ÅµÄÁ˽â
Ïë½øÒ»²½Ñ§Ï°Ò»Ð©ÉîÈëµãµÄ¶«Î÷£ºÊý¾Ý¿âÐÔÄÜÓÅ»¯ºÍÊý¾Ý¿â±¸·ÝÓë»Ö¸´µÈÏà¹ØµÄ֪ʶ¡£
ÄÄλ´óϺÓкõÄѧϰÊé¼®ÍÆ¼öÒ»ÏÂ
²»ÊÇ˵µÄµç×ÓÊé¹þ£¬³ö°æÉç³ö°æµÄ
ллÁË
ºÜ¼±µÄ£¬ÔÚÏߵȡ£Èý¸öСʱºòÎÒ¾ÍҪȥÊéµêÁË
¡¶Oracle 10g ÐÔÄܵ÷ÕûºÍÓÅ»¯¡·
------------------------------------------------------------------------------
Blog£º http://blog.csdn.net/tianlesoftware
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net
Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q Ⱥ£º62697716
ÓÐÊÊÓ¦³õѧµÄÂð£¿ÍƼöһϣ¬Ð»Ð»£¡
Oracle 9i&10g±à³ÌÒÕÊõ£ºÉîÈëÊý¾Ý¿âÌåϵ½á¹¹
Oracle 9i&10g±à³ÌÒÕÊõ ÉîÈëÊý¾Ý¿âÌåϵ½á¹¹
¸ÉÂïҪȥÊéµêÄØ£¬ÔÚÍøÉÏÂò¶àºÃ£¿
ÏÂÁËһЩ£¬¸Ð¾õÓеã³Â¾É
лл¸÷λ´óÏÀ£¬Ð¡µÜºÜÐèÒªÕâÑùµÄÊé¼®¡£
Oracle 9i&10g±à³ÌÒÕÊõ£ºÉîÈëÊý¾Ý¿âÌåϵ½á¹¹
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
¼ÙÉè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;
......
eclipse 3.3Æô¶¯web¹¤³Ì£¬ÒªÁ¬½Óoracle9iÊý¾Ý¿â±¨
ÑÏÖØ: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12518, TNS:listener could not hand off cli ......