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

2 votes267 views2 answers
Install postgresql
SQL
0 vote233 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
0 vote262 views1 answer
Compare two tables to find unmatched records
SQL
0 vote274 views1 answer
Oracle webcenter content search enginer
SQL
1 vote251 views1 answer
Mysql show table character set
SQL
1 vote259 views1 answer
Sql server epoch to datetime
SQL
3 votes209 views1 answer
How to get list of synonyms in oracle
SQL
0 vote276 views1 answer
Sql gather statistics to increase performance
SQL
50 votes374 views6 answers
Sql count duplicate rows
SQL
0 vote254 views1 answer
How to connect pgadmin with excel
SQL