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

0 vote273 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
0 vote269 views1 answer
Sql get month and year from date
SQL
0 vote276 views1 answer
Mysql date minus 1 day
SQL
11 votes712 views4 answers
Reset identity column values in sql server
SQL
6 votes288 views3 answers
Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mydb.term.year' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote307 views2 answers
Mysql dump database tables only
SQL
0 vote271 views1 answer
Sql server order by nulls last
SQL
2 votes281 views2 answers
How to create an empty table from an existing table
SQL
11 votes285 views1 answer
Oracle view ddl
SQL
0 vote295 views1 answer
Oracle to_number
SQL