Proc 正则问题

最新推荐文章于 2024-07-13 18:05:56 发布

iteye_10274

最新推荐文章于 2024-07-13 18:05:56 发布

阅读量122

点赞数

分类专栏： db 文章标签： Mobile SQL C C++ C#

db 专栏收录该内容

6 篇文章

订阅专栏

今天写一段代码非常奇怪.

这个样子居然编译不过


EXEC SQL
			select 'A'||LPAD(SUBSTR(max(MOBILE_MODEL),2)+1,4,'0') into :codeMobileModel.mobileModel
			 from ROUTER.CODE_MOBILE_MODEL where
			 regexp_like(mobile_model , "^A[0-9]{4}");

报
[quote]
PCC-S-02201, Encountered the symbol ";" when expecting one of the following:

= * < > + - / ^= | != <= >= <> at, not, between, in, is,
like, day, hour, minute, month, second, year,
[/quote]

被迫改成


EXEC SQL
			select 'A'||LPAD(SUBSTR(max(MOBILE_MODEL),2)+1,4,'0') into :codeMobileModel.mobileModel
			 from ROUTER.CODE_MOBILE_MODEL where
			 mobile_model like 'A___';

成功编译.

求解中