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

1 vote136 views1 answer
Oracle sql average
SQL
1 vote125 views1 answer
Login to database mysql terminal
SQL
-1 vote135 views1 answer
How to create foreign key in sql server management studio
SQL
8 votes136 views2 answers
Alert table name mysql
SQL
0 vote135 views1 answer
Resullt all update knex mysql
SQL
1 vote123 views1 answer
Hexadec to sql REDSHIFT
SQL
1 vote136 views1 answer
Calculate age in sql postgresql
SQL
11 votes162 views2 answers
Set default column value sql
SQL
1 vote135 views1 answer
Raise application error in oracle
SQL
0 vote124 views1 answer
Sql where time stamp is in between
SQL