Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÎÒ´òËã×°oracle¿Í»§¶Ë ÇëÎÊÈçºÎ×ö£¿

ÊÇÕâÑùµÄ  ÓÐ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ʱ»áÈÃÄãÌîд·þÎñÆ÷µÄÐÅÏ¢£¬ÕýÈ·Ìîд¼´¿É

ÒýÓÃ
ÄÇôÎÒÊý¾Ý¿â°æ±¾ÊÇ 10.1.0.2.0µÄ ÄÜ·ñÏÂÔØ10.2µÄ°æ±¾»òÕß10.1.0.3µÄ°æ±¾
»¹ÊǷǵÃÒ»ÑùµÄ 10.1.0.2.0°æ±¾µÄ¿Í»§¶Ë£¿
Ò»°ãÓø߰汾µÄ¿Í»§¶ËÁ¬µÍ°æ±¾µÄÊý¾Ý¿â²»Ì«ÈÝÒ׳öÏÖÎÊÌâ

ÒýÓÃ
ÊÇÕâÑùµÄ  ÓÐ2̨µçÄÔ Ò»Ì¨×°ÁË 10.1.0.2.0 ÎÒÏë°ÑËüµ±×÷Ò»¸ö·þÎñÆ÷
ÔÚÁíÍâһ̨»ú×ÓÉϰ²×° 10.1.0.2.0µÄ¿Í»§¶Ë Äܹ»Á¬½ÓµÚһ̨µçÄÔ
ÎÒÓÐÒÔÏÂһЩÒÉ»ó£º
ÓбØÒª°²×°¿Í»§¶ËÂð£¿ÊDz»ÊÇÖ»ÐèÒªÔÚµÚ¶þ̨»ú×ÓÉϰ²×°PL/SQL Developer¾Í¿ÉÒÔÁË£¿


Èç¹ûÊÇplsql devÕâÑùµÄ»ùÓÚdllºÍ¿Í»§¶ËµÄ¹¤¾ß£¬Ò»¶¨ÐèÒª°²×°¿Í»§¶ËµÄ¡£

²»¹ýÈç¹ûʵÔÚ²»Ïë°²×°¿Í»§¶Ë£¬¿ÉÒÔÓÃOracle sql developer£¬Õâ¸ö²»ÐèÒª¿Í»§¶Ë£¬ÀïÃæÓÐjdbcµÄthinµÄ·½Ê½£¬²»¹ýÐèÒª°²×°jdk

ÒýÓÃ


Ïà¹ØÎÊ´ð£º

ORACLEÊý¾Ý¿âÖÐµÄ group by Óï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

ÖªµÀÔõô°Ñsasµ¼ÈëoracleµÄ½øÀ´¿´¿´

ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ­ÖªµÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......

lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ

ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿


......

½èˮԴÈËÆø£¡oracle jobÎÊÌ⣡ÔÚÏßµÈ

ÎÒдµÄÒ»¸öJob
declare
  job1 integer;
begin
  dbms_job.submit(job1,
    'Sale_FinanceUseFee(4,null,null,null);',
    TRUNC(SYSDATE)+1.103, ......

oracleÈëÃÅÅäÖÃ

oracleÁ¬½ÓɶÕâô¸´ÔÓ°¡.
oracle 10g
ÓÃps/sql devÔõôҲÁ¬²»ÉÏ.
ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË.
listener.ora:
SID_LIST_LISTENER =
  (SID_LIST =
  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ