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 vote142 views1 answer
Oracle string substitution
SQL
9 votes129 views2 answers
Default number in sql
SQL
0 vote153 views1 answer
How to convert external table to managed table in hive
SQL
0 vote94 views1 answer
Check id exist or not in sql
SQL
4 votes161 views2 answers
Oracle unlock account
SQL
0 vote127 views1 answer
How to print out column name differently in mysql
SQL
0 vote164 views1 answer
Mysql grant user wildcard database
SQL
2 votes137 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
0 vote137 views1 answer
Comparing with today and yesterday record in sql query
SQL
6 votes174 views3 answers
Mysql change auto_increment start value
SQL