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

Oracle how to query whether the string contains%, in view of this question, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and easy way.

1. Use workarounds

Select 'yes' from dual where instr (' ds%fk','%') > 0

two。 Escape using like

Select 'yes' from dual where' abcd%edf' like'/% 'escape' /'

The answer to the question about how to query whether the string contains% in Oracle is shared here. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

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.