Hello
I have a doubt when I use q operator in my select stament with concatenation operator (||).
When I use q operator is the next form
select q'<renny's>' "q<>" from jobs;
It works fine, but if I do this:
select q'<renny's>' "q<>" || 'wife' from jobs;
or
select q'<renny's>' "q<>" || q'<wife>' "q<>" from jobs;
It does not work, but i can find the reason to this error,
ORA-00923: FROM keyword not found where expected
00923. 00000 - "FROM keyword not found where expected"
*Cause:
*Action:
I know there is some other fomr to make this and don't have any case use for this I just want to know why it dosen't work, It's because the q operator dosen't work with concatenation?
Thanks!