Re: sqlplus query

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 16 Mar 2000 21:59:56 +0100
Message-ID: <953243399.22737.0.pluto.d4ee154e@news.demon.nl>

Include the escape clause in the select command.

select ...
from ...
where ... like 'Q_%' escape '_'

from the top of my head no \ needed.

Hth,

Sybrand Bakker, Oracle DBA

Maurice Samuels <samuels_at_red.seas.upenn.edu> wrote in message news:8arblb$oa0$1_at_netnews.upenn.edu...
> if anyone could help me on this one, i'd appreciate it:
>
> the query i want to run is:
> select object_name from user_objects where object_name like 'Q_%';
>
> and the output returns:
> QTEST
> Q_TEST
>
> i only want to see Q_TEST. what do i have to do to get sqlplus to
> literally interpret the Q_ as a Q_
>
> thanks in advance.
> samuels_at_eniac.seas.upenn.edu
Received on Thu Mar 16 2000 - 14:59:56 CST