Re: What is the escape character for Oracle??

From: Lionel Mandrake <nobody_at_nospam.nowhere.nohow>
Date: Tue, 10 Jul 2001 04:52:41 GMT
Message-ID: <tSv27.122127$mG4.60785639@news1.mntp1.il.home.com>

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:52:41 CDT