Square DBA – Oracle DBA Talk

Back from the Christmas holiday and looking forward to New Years.  This week is always slow around here, but I did get a couple of new questions today.  One was a pretty  basic question, but I thought it migh be helpful to someone out there.  What are Oracle wildcards?  There are basically two types, single character and multiple character wildcards.  % is used for multiple characters and _ is used for single characters.  Here are a couple examples.

Single:

SELECT *
FROM wildcard
WHERE test LIKE '23_5';

Multiple:

SELECT *
FROM wildcard
WHERE test LIKE '2%5';