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 vote297 views1 answer
How to find median of a column sql
SQL
0 vote348 views1 answer
Wordpress make wp user in db
SQL
0 vote300 views2 answers
PostgreSQL having
SQL
1 vote284 views1 answer
Mysql show data from table
SQL
1 vote304 views1 answer
Mysql return text after a final full stop
SQL
8 votes300 views1 answer
Alter tablespace add datafile autoextend
SQL
0 vote320 views1 answer
Will graphql replace sql
SQL
0 vote299 views1 answer
Synapse sql table set pk
SQL
0 vote345 views1 answer
Duplicate table: 7 ERROR: relation "migrations" already exists (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))
SQL
0 vote299 views1 answer
Sql find leading space
SQL