ÎÒ´´½¨ÁËÒ»¸öÓû§Ãû USERNAME
µ«ÊÇÈç¹ûÎÒÓÃСдµÄµÇ¼£ºusername¾Í²»ÐС£
ÈçºÎÈÃoracle´´½¨µÄÓû§Ãû²»Çø·Ö´óСд°¡£¿
alter system set sec_case_sensitive_logon=false scope=both;
sec_case_sensitive_logon
Ŷ¡¡µÚÒ»´ÎÌý˵Õâ¸ö²ÎÊý
¿ÉÊÇÎÒÊÔÁËÊÔ ÎªÊ²Ã´¸Ä²»ÁËÄØ
SQL code:
SQL> ......
¿Í»§»·¾³£ºVS2008+Oracle9i
·þÎñÆ÷Êý¾Ý¿â£ºOracle9i
Óöµ½Ò»¸öÎÊÌâ:¿Í»§¶Ë³ÌÐòÖÐÒªµ÷Ó÷þÎñÆ÷ÉϵĴ洢¹ý³Ì¡£ÎÒʹÓÃADO.NETµ÷ÓÃʱϵͳÌáʾ²ÎÊýÀàÐÍ»òÕß²ÎÊý¸öÊý²»ÕýÈ·¡£ÎÒ¼ì²éÒÔºóûÓз¢ÏÖÀàÐÍ´íÎó»òÕß²ÎÊý¸öÊý²»¶Ô¡£
ÓÚÊÇʹÓÃOracleµÄODAC×é¼þ£¨°æ±¾ºÅ-ODP.NET 9.2.0.7.00 £©µ÷ÓÃÒ²ÌáʾÓдíÎó¡£
ÒòΪ×öµ÷ÊÔµ ......
¡¡¡¡ÔÚoralceÖУ¬ÈçÊý¾Ýabc,ÔõÑù²éѯoracleÖÐÄÄЩ±íµÄ¼Ç¼ֵÖк¬ÓÐabc°¡£¬
лл£¡
Õâ¸ö¾Í²»ºÃ²é Òª²éËùÓÐµÄ±í£¬ËùÓеÄ×ֶΡ£
ÓÃÊý¾Ý×Öµä±íÀ´¶¯Ì¬Æ´sql²é¡£²»¹ýÕâÑùµÄ·½·¨Ì«ÍÁÁË£¬Ò²²»ÖªµÀÓÐʲô¸ßЧ·½·¨Ó´¡£
ͨ¹ýÊý¾Ý×ֵ䣬²éÕÒ¶ÔÓ¦ÀàÐ͵Ä×ֶΣ¬ÔÚÕâЩ×Ö¶ÎÀï²éÕÒ
ЧÂʷdz£µÍ£¬¸ßЧµÄ·½·¨Ó¦¸ÃûÓС£Ôõô»áÓ ......
select CanSell,Signed,Records,AveragePrice,housetype,addtime from AC_SellExhilarant where (floor(sysdate - addtime) =1 or floor(sysdate - addtime) = 0) and DISTRICT = :DISTRICT order by decode(Housetype,'סլÀà',0,'ÉÌÒµÀà',1,'°ì¹«Àà',2),AddTime DESC
ÇëÎʸ÷λ¸ßÊÖÕâ¸öÔõà ......
id fund1 fund2
1 0.00 234
2 123 0.00
ÈçÉÏ±í£¬ÎÒÏë¸üРÈç¹û fund1µÄֵΪ0.00ÄÇô¸üÐÂfund2.·´Ö®¸üÐÂfund1
ÎÒдµÄÓï¾äÈçÏ£¬²»ÄÜÖ´ÐÐ
update table a set decode('0.00',fund2,'fund1','fun ......
ÈçÌâ,¼±!Íû´ïÈËÏê½â!
ÓÐÈËÖªµÀÂð?
×Ô¼º¶¥ÏÂ~``
oracle 10gÆóÒµ°æÀïÃæ×Ô´øÁË
Availability
Spatial is installed in most editions of the Oracle RDBMS, but is not licensed in all cases. It is a feature of Database Enterprise Edition, and must be licensed separately. It is not included in the ......