topic Re: Escapw characters within Sql plus in Operating System - HP-UX

Escapw characters within Sql plus

Dave Walley — Mon, 25 Nov 2002 10:42:01 GMT

Good morning.

I am trying to retrieve all objects with an underscore in the name, as an underscore means any single character I cant use that, how can I escape the _ so that it is not interpreted?.

E.g.
select tablespace_name from dba_tablespaces where tablespace_name like 'HELPME_D%';

This query will not return the correct answer.

I look forward to your replies.

Thanks

Dave

Re: Escapw characters within Sql plus

Ian Lochray — Mon, 25 Nov 2002 11:33:46 GMT

Precede the underscore (_) character with an escape character and identify the escape character with the ESCAPE clause i.e
select tablespace_name from dba_tablespaces where tablespace_name like 'HELPME\_D%' ESCAPE '\';

Re: Escapw characters within Sql plus

Christian Gebhardt — Mon, 25 Nov 2002 11:35:49 GMT

Hi

You have to use escape-Sequence from select-Statement

select tablespace_name from dba_tablespaces where tablespace_name like 'HELPME\_D%' escape '\';

Chris