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 votes180 views1 answer
Minecraft forge server host
SQL
0 vote188 views1 answer
Sql query tags
SQL
0 vote181 views1 answer
Initcap in mysql
SQL
11 votes167 views2 answers
Sql rank
SQL
0 vote183 views1 answer
Partitioning in oracle-base
SQL
1 vote187 views2 answers
Sql queries practice
SQL
0 vote187 views1 answer
Hibernate xml property MySQL url, username and password
SQL
0 vote287 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
0 vote178 views1 answer
Sqlalchemy query return only n results
SQL
-1 vote178 views1 answer
How to dump .csv file into mysql
SQL