Escapw characters within Sql plus

[Dave Walley]

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

[Ian Lochray · Accepted solution]

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 '\';

[Christian Gebhardt]

Hi

You have to use escape-Sequence from select-Statement

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

Chris