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

17 votes232 views5 answers
Order by sql
SQL
22 votes262 views4 answers
Date format mysql
SQL
0 vote239 views1 answer
Sum values by month mariadb
SQL
0 vote230 views1 answer
Multiple left join mysql
SQL
0 vote233 views1 answer
Formatting code with SQL Developer
SQL
1 vote247 views1 answer
Partition by sql server
SQL
2 votes254 views1 answer
Postgresql create schema in specific database
SQL
3 votes235 views2 answers
Current year sql
SQL
0 vote243 views1 answer
Flush user resource mysql
SQL
13 votes249 views2 answers
Sql join 3 tables
SQL