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£¬»¹ÓÐÓ
Ïà¹ØÎÊ´ð£º
delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î
http://blog.csdn.net/zxf_feng/archive/2008/12/21/3571961.aspx
¿´¿´Õâ¸ö
ÒýÓÃ
vStream := TMemorySt ......
ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ֪µÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......
RT
×Ö·û´®Óõ¥ÒýºÅ
Ë«ÒýºÅ±íʾ±í, ×Ö¶ÎÃûµÈ¶ÔÏó¡£
ÀýÈç
select * from table_name where id=1;ÕâÖÖ´ú±í²éѯµÄÊÇÊý×Ö
select * from table_name where id='1';ÕâÖÖ´ú±í²éѯµÄÊÇ×Ö·û
Èç ......
ÎÒÔÚ¿ª·¢µçÄÔÉϲâÊÔûÓÐÒ»µãÎÊÌ⣬µ«ÊÇÔÚÐÞ¸ÄÎļþÖеÄÊý¾Ý¿âIPµØÖ·ÒԺ󣬽«warÎļþ·ÅÉϿͻ§µÄµçÄÔÉÏÒÔºóÀÏÊÇ´´½¨Á¬½Óʧ°Ü£¬´íÎóÐÐÔÚ50ÐС£
´´½¨Á¬½Ó´úÂëÈçÏ£º
String proPath = this.getClass().getResource ......
PowerDesigerµ¼³öµÄsql¿ÉÒÔɾ³ý±í¿Õ¼ä
ûÓб¸·Ý±í¿Õ¼äÈçºÎ»Ö¸´?
±ð³Á°¡
ÒýÓÃ
²»ÖªµÀ£¬°ïÄã¶¥£¬»¹ÓУ¬ÄãÎÊ´íµØ·½ÁË£¬µ½oracleÇøÈ¥ÎÊ,itpubÒ²ÊǸöºÃÑ¡Ôñ¡£
......