Escape char in SQL Window

[Paul Ljungqvist]

How do I enter a escape char in the SQL window?

E.g, I this query I want to find all cols with a '
SELECT *
FROM user_col_comments
WHERE table_name = 'KSD_DECLMAIN'
AND comments LIKE '''
/

 

[Theod]

AND comments LIKE '%''%'

 

[Paul Ljungqvist]

Yes, that solves the ' issue, but not my escape question.
How about when using a _ in a query?

I forgot the percent sign in my initial posting.

 

[Marco Kalter]

The LIKE function has an ESCAPE clause. For example:

select * from all_objects
where object_name like 'DBMS\_%' escape '\'