Q operator in plsql

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

5 votes351 views1 answer
Oracle list days between two dates
SQL
0 vote360 views1 answer
Check database restore status sql script
SQL
6 votes329 views5 answers
Alter table oracle
SQL
1 vote313 views1 answer
GROUP BY clause; this is incompati
SQL
12 votes332 views4 answers
Mysql get date difference in hours
SQL
0 vote313 views1 answer
Forcefully delete a row in mysql which has references
SQL
12 votes330 views1 answer
Script to add new column in table sql
SQL
4 votes333 views3 answers
How to describe a table in sqlite3
SQL
0 vote338 views4 answers
Forenkey code alchemy sql
SQL
7 votes315 views2 answers
N highest salary in sql
SQL