Re: What is the escape character for Oracle??

"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
>
>
>

Please check the escape clause of the select command in your sql reference manual.
If you don't have it or didn't install it, it's online at http://technet.oracle.com

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Mon Jul 09 2001 - 12:17:51 CDT