Shulou(Shulou.com)05/31 Report--

This article introduces to you what is the method of querying specific characters in the database storage process, the content is very detailed, interested friends can refer to, hope to be helpful to you.

Replace xx with specific characters, such as "Shenzhen". The sql statement is as follows:

The code is as follows:

Select * from user_source t where instr (lower (t.text), 'xx') > 0 position select * from all_source t where t.ownerSys' and instr (t.textjol'×') > 0

If it is a sql server database, you can use the following statement:

The code is as follows: select * from sysobjects where id in (select id from syscomments where text like'% ×%')

On the database query storage process of specific characters what is shared here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.