ÎÒдһ¸öС³ÌÐòÒª²¶×¥Ä³¸öÍøÒ³µÄhtmlÐÅÏ¢¡£¸ÃÍøÒ³ÉÏÃæÓÐÒ»¸ö°´Å¥£¬µã»÷¸Ã°´Å¥ºóÔڸð´Å¥Î»ÖÃÏ·½»á³öÏÖһЩÒþ²ØÄÚÈÝ(±ÈÈçͼƬ¡¢ÎÄ×Ö)£¬ÎÒÓÃHttpURLConnection×¥µ½µÄhtml¶¼ÊÇûÓгöÏÖÐÂÄÚÈÝǰµÄÒ³ÃæÄÚÈÝ£¬ÎÒÒªÔõô²ÅÄÜ×¥µ½¸Ã°´Å¥µã»÷ºóµÄËùÓÐÒ³ÃæÄÚÈÝÄØ?
ÓÃAJAX,Äã¿ÉÒÔÓõÚÈý·½APIѽ,XHRÖ±½ÓÍµÒ³Ãæ!
Óõϰ,ÎÒµÄ×ÊÔ´Àï ......
±íÖÐÓÐ×Ö¶Îa,b,¾ùΪnumberÀàÐÍ£¬ÏëÔÚselectÖзµ»ØÒ»ÁÐc£¬
Èç¹ûa=b=1,Ôò·µ»ØµÄcÁÐΪ1£¬
·ñÔò·µ»ØµÄcÁÐΪa+b
select £¨case when a=b and a=1 then 1 else a+b end£© as c
from¡£¡£¡£
ÒýÓÃ
±íÖÐÓÐ×Ö¶Îa,b,¾ùΪnumberÀàÐÍ£¬ÏëÔÚselectÖзµ»ØÒ»ÁÐc£¬
Èç¹ûa=b=1,Ôò·µ»ØµÄcÁÐΪ1£¬
......
ÎÒÊÇÔÚlinux oracle11g µ¼³öµÄdmp ÔÚlinux oracle9iÀïµ¼Èë Ìáʾ´íÎó
IMP-00058: ORACLE error 12535 encountered
ORA-12535: TNS:operation timed out
IMP-00000: Import terminated unsuccessfully
ÕâÊÇÔõô»ØÊÂ
¸ß°æ±¾²»Äܵ¼µ½µÍ°æ±¾µÄ
ÒýÓÃ
¸ß°æ±¾²»Äܵ¼µ½µÍ°æ±¾µÄ
up....
--- ......
create table t_temp
(
id varchar2(10) primary key,
len1 number(6,0),
len2 number(6,0),
len number(7,0)
)
µ±updateijһÐеÄlen1»òlen2Öµºó£¬ÔòÐ޸ĸÃÐÐlenµÄÖµ(len = len1 + len2)£¬
»òÕßinsert Ò»ÌõеļǼºó£¬ÐÞ¸Älen = len1 + len2
Ä ......
ÎÒÏÖÔÚ´´½¨ÁËÁ½¸öÊý¾Ý¿â£¬A£¬B£»
ÔÚAÖÐÓÐTAB_A,TAB_B;ÐòÁÐÓÐSEQ_A,SEQ_B;
ÔÚBÖÐÓÐTAB_C,TAB_C;ÐòÁÐÓÐSEQ_C,SEQ_D;
ÓÐʱ»á²éѯ²»µ½±í¸ñ»òÐòÁС£ÔÚPL/SQL developer¹¤¾ßÖпÉÒÔ¿´µ½ÐòÁкͱí¸ñ£¬µ«ÓÃselect * from user_tables;»òselect *
from sequences;È´²é²»µ½ÏàÓ¦µÄ±í¸ñ»òÐòÁУ¬ÎÒÁ¬½ÓµÄÊý¾Ý¿âÓ¦¸ÃûÓÐÁ¬´í¡£Î ......
sql 2005ת oracle³ö´í
sql 2005ÓÐ3¸öimageÀàÐÍ£¬ תµ½ oracle blob³ö´í¡£ÓõÄÊÇSQLµÄµ¼Èëµ¼³ö¹¤¾ß
²é¿´ DTS Ïêϸ
²»ÐоÍÓôúÂëµ¼¡£
¿´À´Ö»ÄÜÓôúÂëÁË
°ï¶¥
jf
´úÂëÁ¿ ²»»áºÜ´ó°É
дÍêÁË Ìù³öÀ´ ѧϰÏÂ
ÎÒÏëÏȰѿÉÒÔÓÃSQL server2005Êý¾ÝÄܵ¼Èëµ½ORACLEµÄ×Ö¶ÎÏȵ¼È룬²»Äܵ¼È ......