Âé·³°ïÎÒдһÌõSQLÓï¾ä - Oracle / »ù´¡ºÍ¹ÜÀí
ÔÚemis.answerlib_1±íÖУ¬ÓÉÓÚʧÎ󣬽«ÁÐanswer ÀïÃæµÄºÜ¶àÊý¾Ý±ä³ÉÕâÑù
Question_ID Answer
1061 abcdabcd
1062 abdabd
¾ÍÊÇÊý¾ÝÖظ´ÁË ÎÒÏë°ÑËü±ä³Éabcd¡¢abdÈ¥³ýÿһÁÐÀïÃæÖظ´µÄÊý¾Ý
update emis.answerlib_1 a set a.answer=( select substr(answer,1,length(answer)/2) from emis.answerlib_1 where Question_ID=a.Question_ID);
ÌáʾÎÞ·¨¸üÐÂ(emis.answerlib_1.answer)ΪNULL
¶øÇÒ²¢²»ÊÇÿһÌõÊý¾Ý¶¼´íÁË...Ö»ÓÐÒ»²¿·ÖÊý¾ÝÊÇ
ÁÐ1£ºQuestion_ID¡¡ ÁÐ2£ºAnswer
¡¡¡¡¡¡¡¡1061 ¡¡¡¡¡¡¡¡¡¡¡¡abcdabcd
¡¡¡¡¡¡¡¡1062 ¡¡¡¡¡¡¡¡¡¡¡¡abdabd
²»»á°É
SQL> create table my(id number,name varchar2(10));
Table created
SQL> insert into my values(1,'abcdabcd');
1 row inserted
SQL> insert into my values(2,'abcabc');
1 row inserted
SQL> commit;
Commit complete
SQL> update my a set a.name=(select substr(name,1,length(name)/2) from my where id=a.id);
2 rows updated
SQL> select * from my;
ID NAME
---------- ----------
1 abcd
2 abc
SQL>
Ŷ ÎÒÃ÷°×ÁË £¬ÕâÑùµÄ»° ¿ÉÄÜÄãҪдһ¸öº¯ÊýÈ¥²ð·ÖÄãµÄAnswer ×ֶΣ¬ÅжÏËûÊÇ·ñÖظ´£¬È»ºóÔÙ½ØÈ¡
ÕæµÄ²»ÐÐ »¹ÊÇÄǸö´í Äã²åÈëÒ»ÌõûÓÐÖظ´µÄÊý¾ÝÊÔÊÔ°¡£¡
ÊÇµÄ ÎÒÒªµÄ¾ÍÊÇÄǸö½á¹û...
ÏÖÔڱȽÏæ ÔÚ´¦ÀíÒ»¸öÒì³£
Ïà¹ØÎÊ´ð£º
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......
oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃMS SQLµÄ´æ´¢¹ý³Ì,Çó½â~лл~
ÒýÓÃ
oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃM ......
¸÷λºÃ£¬ÎÒ¸Õ°ÑÒ»¸öASPÍøÕ¾ÉèÖúÃÁË£¬Ò²ÄÜÕý³£·ÃÎÊ¡£µ«ÊÇÔÚÎÒ±¾»úÉϲ»ÄÜ´ò¿ªadmin\login.asp,ËùÒÔÎÞ·¨ÊµÏÖºǫ́¹ÜÀí¡££¨´íÎóÌáʾÎÞ·¨ÕÒµ½ÍøÒ³£¬´úÂë404£¬ÎҵIJÙ×÷ϵͳÊÇwin2000 server)
µ«ÊÇÆæ¹ÖµÄÊÇÔÚ¾ÖÓòÍøµÄÆäËû» ......