[Oracle] Roles of Wildcard Characters - Percent (%) and Underscore (_)

Tadashi Shigeoka ·  Fri, January 6, 2012

I researched the roles of wildcard characters in Oracle - percent (%) and underscore (_), so here’s a memo.

■ Escaping Special Characters in SQL Statements

Methods for using wildcard characters, percent (%), underscore (_) as extraction conditions in LIKE

●Percent (%) represents 0 or more arbitrary characters

●Underscore (_) represents any single character

・Source: Practical Use of SELECT Statements - Oracle SQL Introduction

That’s all from the Gemba.