oracle ÕýÔò±í´ïʽÎÊÌâ - Oracle / ¿ª·¢

CREAT TABLE TMP_DATACOLLTALE_32 ASSELECT * from TF_TELE_OBJECTS OO WHERE OO.OBJECT_STATE=1 IF(1=1 AND [.evalue] >0 AND [.evalue]<=1800 AND [.IS_HFZJ]=1)THEN /*ACTION*/ END IFEND  

  Ôõôͨ¹ýoracleµÄÕýÔò±í´ïʽÀ´ÌØ»»[.]»ò[] ÖмäµÄÖµ£¬²¢È¥µô[.]~~
ÄÄλ´óÏÀ¾ÈÃüÏÂ~~



 

---

(\[\.)(\w*)(\])¿ÉÒÔÆ¥Åä[.xxxx],xxxx¿ÉÒÔÊÇÈÎÒâ×ÖĸÊý×Ö¡£

±ÈÈçÒª°Ñ[.evalue] ºÍ [.IS_HFZJ] ¶¼Ìæ»»³Éabc¡£ÄÇôÔÚemeditorµÈÖ§³ÖÕýÔò±í´ïʽµÄÎı¾±à¼­Æ÷ÀïÃæ¡£
²éÕÒ(\[\.)(\w*)(\])£¬Ìæ»»³Éabc¾ÍÐÐÁË¡£

Èç¹ûÖ»ÊÇÏ£ÍûÈ¥µôÁ½±ßµÄ[.]£¬ÀïÃæµÄÄÚÈݱ£Áô¡£
²éÕÒ(\[\.)(\w*)(\])£¬Ìæ»»³É\2¡£\2´ú±íµÚ¶þ¸öСÀ¨ºÅÀïÃæµÄ¶«Î÷¡£

---

¶ÔÓÚÄãÉÏÃæµÄÄÚÈݲéÕÒ(\[\.)(\w*)(\])£¬Ìæ»»³É\2¡£
µÄ½á¹ûÊÇ

CREAT TABLE TMP_DATACOLLTALE_32 ASSELECT * from TF_TELE_OBJECTS OO 
WHERE OO.OBJECT_STATE=1 IF(1=1 AND evalue >0 AND evalue <=1800 AND IS_HFZJ=1)THEN /*ACTION*/ END IFEND

---

select regexp_replace('AND [.evalue] >0 AND [.evalue] <=1800 AND [.IS_HFZJ]=1)THEN','(\[\.)(\w*)(\])','\2') from dual;
---------------
AND evalue >0 AND evalue <=1800 AND IS_HFZJ=1)THEN

---

SQL code:


----µÄÈ·²»´í....lsµÄXD
Connected to Oracle Database 11g Enterprise Edition Release 11.1.0.7.0
Connected as billing