Oracle execute immediate quotes

SELECT 'Simple quote''' FROM dual;		-- Simple quote'
SELECT '''Simple quote''' FROM dual;	-- 'Simple quote'

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

Similar codes

0 vote137 views1 answer
SAP Return
SQL
2 votes143 views1 answer
Sqlite indexes
SQL
0 vote144 views1 answer
How to save data in database in mysql node
SQL
0 vote96 views1 answer
Postgresql subquery
SQL
34 votes133 views6 answers
Sql change data type
SQL
4 votes181 views1 answer
Select first and last row sql
SQL
0 vote143 views1 answer
Utiliser sql ligne de commande
SQL
13 votes188 views3 answers
Mysqldump structure only
SQL
3 votes125 views1 answer
Sql timestamp to date
SQL
0 vote125 views1 answer
Sql get month and year from date
SQL