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

13 votes123 views2 answers
Oracle all source
SQL
0 vote252 views3 answers
Get count of null in column sql
SQL
-1 vote161 views2 answers
Sql convert date to string yyyy-mm-dd
SQL
6 votes156 views1 answer
Phpmyadmin reset root password
SQL
0 vote161 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
0 vote161 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL
0 vote125 views1 answer
Sql count how many times a value appears
SQL
16 votes164 views3 answers
Delete row psql
SQL
0 vote170 views1 answer
T sql check active deadlock
SQL
2 votes284 views1 answer
How to create sql database
SQL