ORACLE: How to escape special characters

We often need to escape special characters while retrieving the rows. To do that there are two ways; Use "SET ESCAPE '{ESC CHAR}' End the select statement with 'ESCAPE '{ESC CHAR}' For example; SELECT SL.SYSTEM_CODE, SL.SYSTEM_DESCRIPTION, SL.SYSTEM_PARTICULARS FROM SYSTEMS_LIBRARY SL WHERE SL.SYSTEM_CODE LIKE 'UOTE\_%' ESCAPE '\' the above statement returns all the systems with system …

Continue reading ORACLE: How to escape special characters

Advertisements