linux°²×°oracle xeÔ¶³ÌÁ¬½ÓÎÊÌâ
ÎÒÔÚһ̨ÈËradhat 5.2·þÎñÆ÷Ï°²×°ÁËÒ»¸öoracle10g xeÊý¾Ý¿â£¬±¾µØÁ¬½ÓÒ²ÊÇ¿ÉÒԵģ¬µ«ÊDz»ÖªµÀÔõôµÄ£¬ÎÒÔ¶³ÌÁ¬½ÓÄÇ̨Êý¾Ý¿â£¬×ÜÊDZ¨´í£¬ÎÒ°´ÕÕÊéÉϽ²µÄ»·¾³±äÁ¿Ê²Ã´µÄ¶¼ÉèÖúÃÁË°¡£¬¶øÕâ¸ö°æ±¾Ò²ÊÇÖ§³ÖÔ¶³ÌÊý¾Ý¿âÁ¬½ÓµÄ°¡£¬·À»ðǽÎÒÒ²¹ØÁË£¬ÕæµÄ²»ÖªµÀÄı߳öʲôÎÊÌ⣬Çë¸ßÊÖ°ï°ï棬Íò·Ö¸Ðл£¡£¡£¡
tnsnames.ora ÅäÖùýÁËû£¿
tnsping sid ÄÜ·ñpingͨ£¿
------------------------------------------------------------------------------
Blog£º http://blog.csdn.net/tianlesoftware
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net
Ïà¹ØÊÓƵ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q Ⱥ£º62697716
tnsnames.oraÅäÖùýÁË£¬pingÒ²ÊÇ¿ÉÒÔpingͨµÄ£¬¾ÍÊDz»ÖªµÀÄı߳öµÄÎÊÌâ
°Ñ±¨µÄ´íÌù³öÀ´...
------------------------------------------------------------------------------
Blog£º http://blog.csdn.net/tianlesoftware
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net
Ïà¹ØÊÓƵ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q Ⱥ£º62697716
´íÎó´úÂëÊÇora-12545
ÆÚ´ý¡£¡£
×Ô¼º¶¥ÏÂ
½ñÌìÓа²×°ÁËһ̨Êý¾Ý¿â£¬ÊÇÔÚred hat5.2ÏÂÃæ°²×°oracle11gµÄ£¬ÏÖÔÚ·¢ÏÖ»¹ÊÇÔ¶³ÌÁ¬½ÓÊý¾Ý¿âʵÏÖ²»ÁË£¬¶þ¥˵µÄtnsping sidÊÇÔÚ±¾µØµÄ»¹ÊÇÔÚÔ¶³Ì×öµÄ°¡£¿¸Õ¸ÕÔÚÔ¶³ÌµÄ·´Õý²»ÐУ¬´íÎóÊÇ£º
TNS-12545: ÒòÄ¿±êÖ÷»ú»ò¶ÔÏó²»´æÔÚ, Á¬½Óʧ°Ü
×Ô¼ºÔÙ¶¥ÏÂ
Ê×ÏÈ¿Í»§»úÖ±½ÓpingÊý¾Ý¿âËùÔÚÖ÷»úµÄIP£¬¿´ÊÇ·ñͨµÄ¡£¡£¡£Í¨µÄ»°£¬
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
set A.flag=1
where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
set A.flag=1
where ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
Á½¸öÎļþ1.PC£¬1.inc
1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â
ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË
ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......
OracleÖÐSQLÓï¾äÖÐ
drop table ±íÃû cascadeconstraints
Óë
drop table ±íÃû cascadeconstraint
ÓÐʲôÇø±ð£¿
constraintºÍconstraintsÔÚoracleÖÐÊÇÒ»ÑùʹÓõÄ
¹Ù·½½¨ÒéʹÓÃconstraint
ÒýÓÃ
constraintºÍc ......