ÊÇÕâÑùµÄ ÓÐ2̨µçÄÔ Ò»Ì¨×°ÁË 10.1.0.2.0 ÎÒÏë°ÑËüµ±×÷Ò»¸ö·þÎñÆ÷
ÔÚÁíÍâһ̨»ú×ÓÉϰ²×° 10.1.0.2.0µÄ¿Í»§¶Ë Äܹ»Á¬½ÓµÚһ̨µçÄÔ
ÎÒÓÐÒÔÏÂһЩÒÉ»ó£º
ÓбØÒª°²×°¿Í»§¶ËÂð£¿ÊDz»ÊÇÖ»ÐèÒªÔÚµÚ¶þ̨»ú×ÓÉϰ²×°PL/SQL Developer¾Í¿ÉÒÔÁË£¿
Ҫװ¿Í»§¶Ë£¬ÅäÖÃTNS
ÄÇôÎÒÊý¾Ý¿â°æ±¾ÊÇ 10.1.0.2.0µÄ ÄÜ·ñÏÂÔØ10.2µÄ°æ±¾»òÕß10.1.0.3µÄ°æ±¾
»¹ÊǷǵÃÒ»ÑùµÄ 10.1.0.2.0°æ±¾µÄ¿Í»§¶Ë£¿
¿ÉÒÔ²»Í¬°æ±¾µÄ
Ö§³Ö1Â¥ÐֵܵÄ˵·¨
¿ÉÒÔʹÓò»Í¬°æ±¾µÄ¿Í»§¶Ë£¬²»¹ýҪעÒ⣬oracle11µÄ¿Í»§¶ËÖ»ÄÜÖ§³Ö9iÒÔÉϵÄÊý¾Ý¿â¡£
sql developer¿ÉÒÔ²»ÓÃ×°¿Í»§¶Ë
oracle×Ô¼ºµÄsql developer¿ÉÒÔÖ±½ÓʹÓ㬲»ÐèÒª¿Í»§¶ËµÄ
ʹÓÃsql developerʱ»áÈÃÄãÌîд·þÎñÆ÷µÄÐÅÏ¢£¬ÕýÈ·Ìîд¼´¿É
Ò»°ãÓø߰汾µÄ¿Í»§¶ËÁ¬µÍ°æ±¾µÄÊý¾Ý¿â²»Ì«ÈÝÒ׳öÏÖÎÊÌâ
Èç¹ûÊÇplsql devÕâÑùµÄ»ùÓÚdllºÍ¿Í»§¶ËµÄ¹¤¾ß£¬Ò»¶¨ÐèÒª°²×°¿Í»§¶ËµÄ¡£
²»¹ýÈç¹ûʵÔÚ²»Ïë°²×°¿Í»§¶Ë£¬¿ÉÒÔÓÃOracle sql developer£¬Õâ¸ö²»ÐèÒª¿Í»§¶Ë£¬ÀïÃæÓÐjdbcµÄthinµÄ·½Ê½£¬²»¹ýÐèÒª°²×°jdk
Ïà¹ØÎÊ´ð£º
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ֪µÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
......
ÎÒдµÄÒ»¸öJob
declare
job1 integer;
begin
dbms_job.submit(job1,
'Sale_FinanceUseFee(4,null,null,null);',
TRUNC(SYSDATE)+1.103, ......
oracleÁ¬½ÓɶÕâô¸´ÔÓ°¡.
oracle 10g
ÓÃps/sql devÔõôҲÁ¬²»ÉÏ.
ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË.
listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
......