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 vote209 views2 answers
Sql select inside select
SQL
1 vote237 views1 answer
Sysdate in sql
SQL
5 votes223 views2 answers
Mysql date greater than 30 days
SQL
5 votes218 views1 answer
Oracle generate list of dates in between a date range
SQL
0 vote201 views1 answer
Duplicate foreign key constraint name
SQL
17 votes227 views3 answers
How to change a collumn name in sql
SQL
0 vote235 views2 answers
Jsonb
SQL
4 votes222 views3 answers
Mysql varchar length
SQL
0 vote220 views1 answer
Create new table pl sql
SQL
0 vote242 views1 answer
Change database name psql 8
SQL