Re: What is the escape character for Oracle??

From: Lionel Mandrake <nobody_at_nospam.nowhere.nohow>
Date: Tue, 10 Jul 2001 04:56:02 GMT
Message-ID: <CVv27.122142$mG4.60791542@news1.mntp1.il.home.com>

Sorry... fat-fingered it...

select *
from dba_role_privs
where grantee like 'TEST\_%' escape '\' /

"Fie" <pub_Fie_at_hotmail.com> wrote in message news:9icial$1dg2$1_at_scavenger.euro.net...
> Select *
>
> from dba_role_privs
>
> where grantee like 'TEST_%'
>
> The underscore should not be taken as the random sign but as the char "_"
!!
>
> For this I need the escape-char.
>
> Sofie
>
> [PIAS] Play It Again Sam
>
> Reply do
>
> Sofie.Kempeneer_at_pias.be
>
>
>
Received on Mon Jul 09 2001 - 23:56:02 CDT