Q operator in oracle

q'{something_something}'

usage:
select q'{here i'm gonna use all kinds of characters "'" included}' from dual;
select q'[i can delimitate this field with a lot of characters]' from dual;
select q'wincluding letters! that's amazingw' from dual;

Similar codes

7 votes199 views1 answer
Grant schema permissions postgres
SQL
0 vote295 views1 answer
Oracle db get table sizes
SQL
0 vote265 views1 answer
Oracle current date minus 1 day
SQL
0 vote162 views1 answer
Store query result in variable sql
SQL
1 vote214 views1 answer
Delete dublicate rows sql
SQL
0 vote195 views3 answers
How to run sql query
SQL
0 vote212 views1 answer
Mysql aspas simples
SQL
94 votes416 views4 answers
Create database postgres
SQL
0 vote167 views1 answer
Oracle sql replace string in clob
SQL
1 vote189 views1 answer
Setval pgsql
SQL