Oracle simple quote

SELECT 'Simple quote''' FROM dual;		-- Simple quote'
SELECT '''Simple quote''' FROM dual;	-- 'Simple quote'
SELECT q'['Simple quote']' from dual;	-- 'Simple quote'  q'[my_string]'

s_date VARCHAR2(10 BYTE) := '12/02/2021';
EXECUTE IMMEDIATE 'SELECT to_date(''' || s_date || ''', ''DD/MM/YYYY'') FROM dual';

Similar codes

6 votes295 views2 answers
Mysql execute file
SQL
18 votes271 views6 answers
Drop table if exists
SQL
3 votes306 views5 answers
Sql select
SQL
1 vote282 views2 answers
Create table if not exist
SQL
11 votes295 views3 answers
How to get last row of table in sql
SQL
0 vote257 views1 answer
Sql python hwo to pass a list in paramerter
SQL
0 vote309 views1 answer
Joomla execute raw sql
SQL
1 vote260 views1 answer
Sql only five first row
SQL
-1 vote276 views1 answer
How to create foreign key in sql server management studio
SQL
0 vote264 views2 answers
How to see table associated with a schema in sql
SQL