linux °²×°oracle ²ÎÊýÌáʾPORTµÄÖµNULLÎÞЧ
linux °²×°oracleʱ£¬Ìáʾ ²ÎÊýÌáʾPORTµÄÖµNULLÎÞЧ£¿ Ôõô½â¾öÄØ¡£
ÔÚÄÄÒ»²½³öÏÖÕâ¸ö´íÎóµÄ£¿ ÃèÊöÇå³þÒ»µã...
ÊÇÔÚ°²×°¹ý³ÌÖе¯³ö¿òÌáʾ¡£
Ðֵܣ¬ÓÐÎÊÌâҪ˵Çå³þLINUX°æ±¾¡¢ORACLE°æ°¡£¿
Red Hat Enterprise Linux 4(Update 5)
Oracle : 10g
Ïà¹ØÎÊ´ð£º
дÁ˸ö²âÊÔ³ÌÐòÈçÏÂ
struct hostent *hp;
char AlarmDevIP[20];
int x2;
hp = gethostbyname("www.google.com");
if (hp)
{
......
ÎÒ¶Ô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 ......
ÎÊÌâÃèÊö£º
1¡¢¼ÙÉèÓбí
t1±í£¬°üº¬ËÄÁÐ
s1 a b c
1 a a a
2 b b b
.........
t2±í£¬°üº¬2ÁÐ
s2 ff
1 77
2 88
............
ÈçºÎÉú³ÉÕâÑùµÄºÏ²¢Ê ......