Re: Reverse pattern matching

Jonathan Leffler wrote:
> In IBM Informix Dynamic Server (IDS), you'd do:
>
> SELECT b FROM t WHERE 'XYZ' LIKE a;

The solution is the same in Oracle:

SQL> select * from t;

A                   B
---------- ----------
AB%                 1
X%                  2
XY%                 3
%                   4

SQL> select * from t where 'XYZ' like a;

A                   B
---------- ----------
X%                  2
XY%                 3
%                   4