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

8 votes143 views3 answers
Mysql alter table add index
SQL
5 votes332 views2 answers
How to ascending order in sql
SQL
6 votes157 views3 answers
Mysql first day of year
SQL
0 vote151 views1 answer
Psql list view rules
SQL
2 votes165 views3 answers
Sql delete duplicate
SQL
2 votes152 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
0 vote173 views1 answer
Postgresql cast as year and month from timestamp
SQL
0 vote141 views1 answer
Psql list rules
SQL
0 vote149 views1 answer
Can we rollback in sql
SQL
0 vote317 views1 answer
Why do we need data structure in sql
SQL