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

oracle µÇ²»ÉÏ

ÎÒ°²×°µÄÊÇOracle10G£¬°²×°Ë³ÀûûÎÊÌ⣡·þÎñÒ²ÄÜÕý³£Æô¶¯£¡
µÇ½ʱ³öÏÖ£º"ora-12514:  TNS:¼àÌý³ÌÐòµ±Ç°ÎÞ·¨Ê¶±ðÁ¬½ÓÃèÊö·ûÖÐÇëÇóµÄ·þÎñ£¡
¼´Ê¹ÖØ×°Ò²»¹ÊÇÕâ¸öÎÊÌ⣡
ÇëÎÊ´óÏÀÃÇÕâÊÇʲôԭÒòÒýÆðµÄ°¡£¿Ð»Ð»£¡
SQL code:
--¼àÌýûÓÐÅäÖúã¬ÖØÐÂÅäÖÃһϼàÌý


¼àÌýÔõôÅäÖ𡣿ËÑË÷ÁËһϣ¬ºÃÏñû¼ûµ½Ê²Ã´ÓÐÓõģ¡
ÇëÂ¥Éϸø¾ßÌåÖ¸µ¼Ò»ÏÂлл£¡

F:\oracle\db_1\NETWORK\ADMINÏÂlistener.oraÎļþÎÒÐÞ¸ÄÈçÏ£º
# listener.ora Network Configuration File: f:\oracle\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = f:\oracle\db_1)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  )


F:\oracle\db_1\NETWORK\ADMINÏÂtnsnames.oraÐÞ¸ÄÈçÏ£º
# tnsnames.ora Network Configuration File: f:\oracle\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration to


Ïà¹ØÎÊ´ð£º

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

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

ÇóʹÓÃt-sqlÓï¾ä½«paradoxÊý¾Ýµ¼ÈëoracleµÄ°ì·¨

ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......

ÖªµÀÔõô°Ñ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Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿


......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ