Oracle条件检查 [英] Oracle condition checking
本文介绍了Oracle条件检查的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何在where子句中对此进行检查
how to check this in where clause
这应该返回false 'thousand'='usa'
This should return false 'thousand'='usa'
这应该返回false 'canada','tower'='canada'
This should return false 'canada','tower'='canada'
这应该返回true 'south','africa'='south africa'
This should return true 'south','africa'='south africa'
推荐答案
Oracle安装程序:
CREATE TABLE your_table ( strname ) AS
SELECT '''canada'',''tower''' FROM DUAL UNION ALL
SELECT '''south'',''africa''' FROM DUAL;
查询:
SELECT *
FROM your_table
WHERE strname LIKE '%''' || lower( 'canada' ) || '''%'
输出:
STRNAME
----------------
'canada','tower'
查询:
SELECT *
FROM your_table
WHERE strname LIKE '%''' || lower( 'south' ) || '''%'
AND strname LIKE '%''' || lower( 'africa' ) || '''%'
输出:
STRNAME
----------------
'south','africa'
这篇关于Oracle条件检查的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文