The use of wildcards% and _ for Oralce rookie learning
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