Get the App
SLTechnology News&Howtos  ›  Database  › 

The use of wildcards% and _ for Oralce rookie learning

Shulou Source: shulou.com Published: 2022-06-01 21:24:35 11月17日 Update

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

Tags: Wildcards learning rookies underscores characters Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Shulou Tech Info Apple Huawei Shulou Information vpn