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

delphiÖÐÓÃadoÁ¬½Óoracle 10g

2009-12-01  00:41:35
֮ǰ°²×°ÁËoracle 10g£¬ºóÀ´ÎªÁËÔÚC#ÀïÃæÁ¬½Óoracle£¬°²×°ÁËODAC£¬Ö®ºóÁ¬½ÓÊý¾Ý¿âʱ£¬ÌîдÊý¾Ý¿â·þÎñÃû£¬×ÜÊÇ»á³ö´í£¬Á¬½Ó²âÊÔÎÞ·¨Í¨¹ý£¬²»ÌîÊý¾Ý¿â·þÎñÃû£¬µ¹»¹¿ÉÒÔͨ¹ýÁ¬½Ó²âÊÔ
½ñÍíÖÕÓڲ鵽ԭÒòÁË¡£¡£¡£
ϵͳÊôÐÔÄÇÀïµÄ»·¾³±äÁ¿£¬pathÕâÀoracleµÄÁ½¸öĬÈÏ·¾¶£º
d:\oracle\product\10.2.0\db_1\bin;
D:\oracle\product\10.2.0\client_1;
µÚÒ»¸öÊÇoracleµÄ¿Í»§¶Ë£¬µÚ¶þ¸öÊÇODACµÄ£¬Á½¸öÔÚpathµÄ˳Ðò£¬²»Äܵߵ¹£¬±ÈÈ磺
D:\oracle\product\10.2.0\client_1;d:\oracle\product\10.2.0\db_1\bin;
¾Í»á³ö´íÀ²……µ÷ÕûÁ½¸öµÄ˳Ðò£¬²âÊÔͨ¹ý
µÚÒ»´ÎÓÃdelphiµÄadoÁ¬½ÓÊý¾Ý¿â£¬Á¬½Ó²½Ö裺
¿Ø¼þadoconnectionË«»÷£¬µã»÷buildÉèÖþÍÐÐÁË£¬Óû§ÊäÈëscott£¬ÃÜÂëtiger£¬
ÔÙ¼ÓÈëadoquery£¬connectionÑ¡adoconnection1£¬sqlÑ¡ÏîÀïÃæÐ´Èësql£¬
¼ÓÈëdatasource£¬datasetΪadoquery1£¬
ÔÚadoquery1µÄsalÊôÐÔÖУ¬¼ÓÈëÒ»Ìõ²âÊÔÓõÄsqlÓï¾ä£¬¾äÄ©²»Ó÷ֺœ£»”²»È»Ö´Ðв»ÁË£¬½Ó×ÅÉèÖÃadoquery1¡¢adoconnection1µÄactiveΪtrue
¼ÓÈëdbgrid£¬datasourceΪdatasource1£¬Ó¦¸Ã¾ÍÄÜ¿´¼ûÁË£¬Õâ¸ö¾ÍÊǼòµ¥µÄʹÊý¾ÝÏÔʾ³öÀ´


Ïà¹ØÎĵµ£º

oracleÊý¾Ý¿âѧϰ£¨ZT£©

 oracleµÄÌåϵ̫ÅÓ´óÁË£¬¶ÔÓÚ³õѧÕßÀ´Ëµ£¬ÄÑÃâ»áÓÐЩÎÞ´ÓÏÂÊֵĸоõ£¬Ê²Ã´¶¼Ïëѧ£¬½á¹ûʲô¶¼Ñ§²»ºÃ£¬ËùÒÔ°Ñѧϰ¾­Ñé¹²Ïíһϣ¬Ï£ÍûÈøոÕÈëÃŵÄÈ˶ÔoracleÓÐÒ»¸ö×ÜÌåµÄÈÏʶ£¬ÉÙ×ßһЩÍä·¡£ 
Ò»¡¢¶¨Î» 
oracle·ÖÁ½´ó¿é£¬Ò»¿éÊÇ¿ª·¢£¬Ò»¿éÊǹÜÀí¡£¿ª·¢Ö÷ÒªÊÇдд´æ´¢¹ý³Ì¡¢´¥·¢Æ÷ʲôµÄ£¬»¹ÓоÍÊÇÓÃOracle ......

oracleÆô¶¯¼àÌý³öÏÖTNS 12547´íÎó

ÏÖÏó£º
oracleÆô¶¯¼àÌý£¬±¨¸æÈçÏ´íÎó£º
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 32: Broken pipe
Ô­Òò£º
lisenter.log ÎļþÌ«´óÁË,OracleÎÞ·¨¶ÔËü½øÐвÙ×÷ÁË£¬µ¼ÖÂlistenerÎÞ·¨Õý³£Æô¶¯¡£
listener.log ³¬¹ý2G¾Í»á³öÎÊÌâ
·½·¨£º
·¨1. ÒÆ³ýÔ­$ ......

oracle ²é¿´Ö÷Íâ¼üÔ¼Êø

select a.constraint_name, a.table_name, b.constraint_name 
from user_constraints a, user_constraints b
where a.constraint_type = 'R' 
and b.constraint_type = 'P' 
and a.r_constraint_name = b.constraint_name
P ´ú±íÖ÷¼ü
R ´ú±íÍâ¼ü
ͨ¹ý¹ØÁª£¬Äܲéѯµ½ÄãËùÏëÒªµÄÒ»ÇС£
select co ......

CMDÏ´´½¨OracleÊý¾Ý¿â£¨ÒÔOracle10gΪÀý£©

Ò»¡¢ÔÚUnixÏ´´½¨Êý¾Ý¿â
1.È·¶¨Êý¾Ý¿âÃû¡¢Êý¾Ý¿âʵÀýÃûºÍ·þÎñÃû
¹ØÓÚÊý¾Ý¿âÃû¡¢Êý¾Ý¿âʵÀýÃûºÍ·þÎñÃû£¬ÎÒ֮ǰÓÐרÃÅÓÃһƪÀ´Ïêϸ½éÉÜ¡£ÕâÀï¾Í²»ÔÙ˵Ã÷ÁË¡£
2.´´½¨²ÎÊýÎļþ
     ²ÎÊýÎļþºÜÈ·¶¨ÁËÊý¾Ý¿âµÄ×ÜÌå½á¹¹¡£Oracle10gÓÐÁ½ÖÖ²ÎÊýÎļþ£¬Ò»¸öÊÇÎı¾²ÎÊýÎļþ£¬Ò»ÖÖÊÇ·þÎñÆ÷²ÎÊýÎļþ¡£ÔÚ´´½¨Ê ......

ÓÃCodeSmith±àдģ°åµ¼³öOracleÖбíµÄÊý¾Ý 2

ʹÓÃCodeSmithÉú³ÉoracleÊý¾Ý¿â±íµÄʵÌå²ã(Model)
http://blog.csdn.net/dacong/archive/2009/01/27/3853663.aspx
×Ô¼ºÐ´µÄ£¬CodeSimthÖеÄÀý×Ó¶¼ÊÇmsSQL serverµÄ£¬ËùÒÔ×Ô¼ºÐ´Á˸öÖ§³ÖOracleÊý¾Ý¿â±íµÄ£¬²»Ò»¶¨ºÜÍêÉÆ£¬ÊÊÓþͺã¬Êý¾ÝÀàÐÍûÓÐÖÜÈ«¿¼ÂÇ£¬Ö»¿¼ÂÇÁ˳£ÓõÄһЩÀàÐÍ£¬Ôö¼ÓÁ˸ö±íÃû×ÖÊôÐÔ£¬²ÉÓõÄ.net2.0ÎÒ½á ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ