Re: escape colon char

On 18/08/2016 4:02 PM, Ray Stell wrote:
>> note the beginning q'[ and ending ]';
>>
> Ingrid Voigt pointed out privately that two single quotes solves the
> problem just as Andy Wattenhofer posted, also. So simple... Not sure
> if your hack will work or not. I did try various brace attempts
> before I posted. Like this:
>

The 'alternative quote mechanism' (q'? ?') is well suited to resolve the confusion that can arise from trying to embed quotes in an expression.. Well documented at
https://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements003.htm

/Hans

--
http://www.freelists.org/webpage/oracle-l