Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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£¬»¹ÓÐÓ


Ïà¹ØÎÊ´ð£º

delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î

delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î

http://blog.csdn.net/zxf_feng/archive/2008/12/21/3571961.aspx
¿´¿´Õâ¸ö

ÒýÓÃ
            vStream := TMemorySt ......

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

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

oracleµÄµ¥ÒýºÅ ºÍË«ÒýºÅµÄÎÊÌâ ÒÉ»ó¡£

RT

×Ö·û´®Óõ¥ÒýºÅ
Ë«ÒýºÅ±íʾ±í, ×Ö¶ÎÃûµÈ¶ÔÏó¡£

ÀýÈç
select * from table_name where id=1;ÕâÖÖ´ú±í²éѯµÄÊÇÊý×Ö
select * from table_name where id='1';ÕâÖÖ´ú±í²éѯµÄÊÇ×Ö·û
Èç ......

oracleÁ´½ÓÎÊÌâ

ÎÒÔÚ¿ª·¢µçÄÔÉϲâÊÔûÓÐÒ»µãÎÊÌ⣬µ«ÊÇÔÚÐÞ¸ÄÎļþÖеÄÊý¾Ý¿âIPµØÖ·ÒԺ󣬽«warÎļþ·ÅÉϿͻ§µÄµçÄÔÉÏÒÔºóÀÏÊÇ´´½¨Á¬½Óʧ°Ü£¬´íÎóÐÐÔÚ50ÐС£
´´½¨Á¬½Ó´úÂëÈçÏ£º
String proPath = this.getClass().getResource ......

Oracle±í¿Õ¼ä»Ö¸´

PowerDesigerµ¼³öµÄsql¿ÉÒÔɾ³ý±í¿Õ¼ä

ûÓб¸·Ý±í¿Õ¼äÈçºÎ»Ö¸´?
±ð³Á°¡


ÒýÓÃ
²»ÖªµÀ£¬°ïÄã¶¥£¬»¹ÓУ¬ÄãÎÊ´íµØ·½ÁË£¬µ½oracleÇøÈ¥ÎÊ,itpubÒ²ÊǸöºÃÑ¡Ôñ¡£
           ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ