"Adriano dos Santos Fernandes" ...

> All,
>
> Oracle has a feature where you can use quotes inside strings without
> need to double them.
>
> Here is a example:
> select q'!where name = 'xyz'!' from dual;
> Result: where name = 'xyz'
>
> And another one:
> select q'{where name = 'xyz'}' from dual;
> Result: where name = 'xyz'
>
> When the opening character is "[", "{", "(" or "<", the closing one is
> respectively "]", "}", ")" and ">". In other cases, the opening and
> closing shall be identical.
>
> The strings really terminates in <close char><quote>, so you can even
> use that character inside it.

What if i need this sequence inside my literal ? What if literal is user-defined
and we can't prevent user from entering this sequence ?

Regards,
Vlad