Oracle simple quote

SELECT 'Simple quote''' FROM dual;		-- Simple quote'
SELECT '''Simple quote''' FROM dual;	-- 'Simple quote'
SELECT q'['Simple quote']' from dual;	-- 'Simple quote'  q'[my_string]'

s_date VARCHAR2(10 BYTE) := '12/02/2021';
EXECUTE IMMEDIATE 'SELECT to_date(''' || s_date || ''', ''DD/MM/YYYY'') FROM dual';

Similar codes

1 vote202 views1 answer
Grab all records from one table to another oracle sql
SQL
2 votes195 views4 answers
Check timezone of mysql database
SQL
5 votes194 views1 answer
Sqlite alter table add column
SQL
0 vote191 views1 answer
How to print out column name differently in mysql
SQL
3 votes187 views2 answers
Current year sql
SQL
0 vote216 views1 answer
Oracle sql drop table
SQL
14 votes197 views2 answers
Oracle limit rows
SQL
5 votes234 views2 answers
Create table mysql example auto_increment
SQL
3 votes187 views1 answer
What is having clause
SQL
0 vote302 views3 answers
CONTACT FORM SQL
SQL