Shulou(Shulou.com)06/01 Report--

Debut: http://www.arppinging.com/wordpress/?p=104

The use of Oralce rookie learning wildcards% and _ 1,%

In Oracle,% means to match all, and use like before using wildcards

SQL > select * from student where sname like'Z% ZhaoYun 24SQL; SNO SNAME SAGE- 1 ZhangSan 21 4 ZhaoYun 24SQL > 2, _

The underscore'_'in Oracle indicates any match of a character.

SQL > select * from student where sname like 'ZhaoYu_'; SNO SNAME SAGE--4 ZhaoYun 24

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.