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 vote337 views2 answers
Sql where is not number
SQL
8 votes316 views1 answer
Similarities between ddl and dml
SQL
13 votes351 views2 answers
Mysql order by multiple columns
SQL
0 vote365 views1 answer
Postgresql on conflict pair
SQL
0 vote335 views1 answer
Vbscript create ADODB.Connection
SQL
0 vote360 views1 answer
Phpmyadmin tabellentyp ändern
SQL
150 votes643 views10 answers
Grepper
SQL
2 votes405 views1 answer
Oracle find constraints referencing a table
SQL
0 vote359 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
0 vote377 views1 answer
Exectuer myssql .sql
SQL