[Oracle] Roles of Wildcard Characters - Percent (%) and Underscore (_)
I researched the roles of wildcard characters in Oracle - percent (%) and underscore (_), so here’s a memo.
■ Escaping Special Characters in SQL StatementsMethods 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.