sql regular expression
来源:互联网 发布:usb转网络接口 税号 编辑:程序博客网 时间:2024/06/06 04:10
SELECT
ID,
CAR_NUM
FROM
HZ_JJCD
WHERE
CAR_NUM NOT IN (
SELECT
CAR_NUM
FROM
HZ_JJCD
WHERE
REGEXP_LIKE (
CAR_NUM,
'(^[+-]?\d{0,}\.?d{0,}$)'
)
)
ORDER BY
"ID"
ID,
CAR_NUM
FROM
HZ_JJCD
WHERE
CAR_NUM NOT IN (
SELECT
CAR_NUM
FROM
HZ_JJCD
WHERE
REGEXP_LIKE (
CAR_NUM,
'(^[+-]?\d{0,}\.?d{0,}$)'
)
)
ORDER BY
"ID"
0 0
- sql regular expression
- Oracle SQL 正则表达式(regular expression)
- regular expression
- Regular Expression
- regular expression
- Regular Expression
- Regular Expression
- regular expression
- Regular Expression
- Regular Expression
- regular expression
- Regular expression
- Regular Expression
- Regular Expression
- regular expression
- Regular expression
- regular expression
- regular expression
- 将ArrayList中有警报的数据放到ArrayList的最前面。
- ionic 编译Android 出现No installed build tools found的解决方法
- Java中同一个类下一个方法怎样访问另一个方法下的变量
- 关于web.xml启动spring容器的配置文件的建议
- 线程安全
- sql regular expression
- Oracle学习之共享锁和排他锁
- postgresql 递归查询
- Android 内置FM频道
- 手机端网页web开发要点
- Android GridView属性
- 最强 Android Studio 使用小技巧和快捷键
- Git起步
- linux 实战一 安装服务器