In a nutshel Turn of special meaning of chars -- The ampersand has no special meaning anymore SET DEFINE OFF; SELECT 'V&D' FROM dual; Escaping characters in LIKE -- The meaning of the underscore is escaped SET ESCAPE ON; SELECT * FROM maxtable WHERE tablename LIKE 'A\\_%' ESCAPE '\\';