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

OracleÈçºÎÁ¬½ÓÔ¶³Ìoracle?

±ðÈ˸øÁËÎÒÔ¶³ÌoracleÊý¾Ý¿âµÄÐÅÏ¢£º¹Ì¶¨IP£¬¶Ë¿ÚºÅºÍSID£¬»¹ÓÐÓû§ÃûºÍÃÜÂ룬ËûµÄÊý¾Ý¿âÊÇoracle9i,ÎÒµÄÒ²ÊÇ£¬ÎÒÈçºÎ²ÅÄÜÁ¬½Óµ½ËûµÄÊý¾Ý¿âµÃµ½Êý¾Ý£¬Çë¸ßÊÖ°ïæָµãһϣ¬²»Ê¤¸Ðл£¡


ÎÊÌâûÓнâ¾ö
wildwave£¬ÄúºÃ,¿É²»¿ÉÒÔÁô¸öµç»°Çë½ÌÒ»ÏÂ,¼±ÓÃÕâ¸ö£¬Ð»Ð»À²

Îҵĵ绰ÊÇ£º15934489110

»¹ÓÐÒ»µã£¬ÎÒ²»ÊÇÔÚ¾ÖÓòÍøÖзÃÎÊ£¬¶øÊÇÔÚinternetÍøÖзÃÎÊÄØ£¬Çë´ó¼Ò°ïÏÂæ

ÓÐʲôÎÊÌâ¾ÍÔÚÕâÀï˵°É£¬ÎÒÊÖ»úûµçÁË
»òÕß¿ÉÒÔÇë½Ìtianlesoftware£¬Õâ·½ÃæËû±ÈÎÒÇ¿µÃ¶à

Èç¹ûÊǹ̶¨ip£¬Ó¦¸ÃÒ²¿ÉÒԵġ£È·¶¨¶Ô·½Ïà¹Ø·þÎñ¶¼Õý³£Æô¶¯£¬ÅäÖúÃtnsnames
¾Í¿ÉÒÔÁ¬½Ó
×¢ÒâÍøÂçÎÊÌâ
ÏÈÊÔÊÔÄÜ·ñpingµÃͨ


ÅäºÃtnsname.oraºó£¬
ÓÃtnsping SIDÊÔÏ£¬ÄÜpingͨ¾Í¿ÉÒÔÁ¬ÉÏÁË..

SQL code:

C:\Documents and Settings\user.HQ-TEXT>tnsping DBA

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 22-10ÔÂ-
2009 19:09:14

Copyright (c) 1997, 2005, Oracle. All rights reserved.

ÒÑʹÓõIJÎÊýÎļþ:
D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora


ÒÑʹÓà TNSNAMES ÊÊÅäÆ÷À´½âÎö±ðÃû
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = HFCC-KF-
3068)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DBA.anq
ingren.org)))
OK (30 ºÁÃë)



ÎÒÖØÐÂÏêϸµØËµÃ÷Ò»ÏÂÎÒµÄÎÊÌ⣺
ÎÒÔÚɽÎ÷£¬ÎÒÒª·ÃÎʹ㶫µÄOracle·þÎñÆ÷£¬Ëû¸øÎÒÌṩÁ˹̶¨IP,¶Ë¿ÚºÅÒÔ¼°SID£¬»¹ÓÐÓ


Ïà¹ØÎÊ´ð£º

linux + oracleÓÃXP·ÃÎʲ»ÁË

ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬

-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......

oracle sql developer ²éѯÏÔʾÖÐÎÄÂÒÂë

»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£ ......

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

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

¼±Ñ°Oracle ERPʵʩ¹ËÎÊ

3-5ÈË£¬¹¤×÷µØµãÉϺ£ÆÖ¶«Èí¼þÔ°£¬2-3Äê¾­Ñ飬ӢÎÄÁ÷Àû£¬ÓÐÒâÕßÇëÁªÏµ38954510-1355£¬15821699737£¬y.ming@live.cn
×Ô¼º¶¥¡£¡£¡£

ûÓÐORACLE ERPµÄ¾­Ñé,ÓÐÓÃÓѺÍTIPTOP¾­Ñé,Ó¢Óï˵²»ºÃ,¿´»¹ÊÇ¿ÉÒÔ!
²»ÖªµÀÓÐûÓÐ ......

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ºÅ