Many SQL statements use character literals in expressions or conditions. If the literal itself contains a single quotation mark, you can use the quote (q) operator and choose your own quotation mark delimiter.
You can choose any convenient delimiter, single-byte or multibyte, or any of the following character pairs: [], {}, (), or <>.
EX: select q'<Oracle's quote operator>' from dual;
select q'#Oracle's quote operator#' from dual;
select q'(Oracle's quote operator)' from dual;
select dname ||q'{ it's assigned manager id :}'|| mgr from emp,dept where emp.deptno=dept.deptno
can you explain (convenient delimiter, single-byte or multibyte) with an example.
ReplyDelete