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 vote188 views1 answer
Download mysql database to excel in android studio
SQL
0 vote161 views1 answer
Provide hardcoded value in the mysql query
SQL
0 vote152 views1 answer
With_for_update sqlalchemy
SQL
1 vote149 views1 answer
Sql server find tables referenced foreign key
SQL
0 vote155 views1 answer
Cast as decimal postgresql
SQL
-1 vote165 views1 answer
Spring boot mysql connection properties
SQL
0 vote164 views1 answer
Sql server user permissions and roles
SQL
0 vote203 views1 answer
Liquibase update row
SQL
0 vote142 views1 answer
Metada in sql
SQL
4 votes169 views1 answer
Sql quote in string
SQL