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

0 vote197 views2 answers
Mysql updating multiple column values from array variable
SQL
0 vote197 views1 answer
Sql count null as 0
SQL
0 vote200 views1 answer
Get all employees if name ends with in sql
SQL
0 vote219 views1 answer
Sql database connectivity
SQL
1 vote265 views1 answer
How to put value in variable mysql
SQL
5 votes271 views1 answer
Oracle columns in all_tables
SQL
0 vote219 views1 answer
Except in sql
SQL
0 vote206 views1 answer
Dbms_output sql developer
SQL
4 votes221 views1 answer
Mysql ip address data type
SQL
1 vote198 views1 answer
Postgresql transaction discard all
SQL