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

11 votes149 views2 answers
MySQL DISTINCT
SQL
16 votes151 views4 answers
Mysql import from sql file
SQL
0 vote157 views1 answer
Window function to forward fill
SQL
0 vote177 views1 answer
SQL get max per id
SQL
1 vote166 views1 answer
Sql first day quarter
SQL
0 vote155 views1 answer
Sql server concat null
SQL
0 vote171 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
0 vote140 views1 answer
Postgres week number
SQL
1 vote141 views3 answers
How to truncate foreign key constraint table
SQL
0 vote172 views1 answer
Selecting Multiple Columns in SQL
SQL