Oracle DB：我如何写查询忽略大小写？ [英] Oracle DB: How can I write query ignoring case?

问题描述

正如我写的标题，我有SQL查询，运行在Oracle DB上，让我们说：

As I had written in title, I have SQL query, run on Oracle DB, lets say:

SELECT * FROM TABLE WHERE TABLE.NAME Like 'IgNoReCaSe'

如果我希望查询将返回

If I would like, that the query would return either "IGNORECASE", "ignorecase" or combinations of them, how can this be done?

这可能吗？

推荐答案

您可以使用ALTER SESSION语句将比较设置为不区分大小写。请参阅此常见问题。

You can use ALTER SESSION statements to set comparison to case-insensitive. See this FAQ.

alter session set NLS_COMP=ANSI;
alter session set NLS_SORT=BINARY_CI;

这篇关于Oracle DB：我如何写查询忽略大小写？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！