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

0 vote265 views1 answer
TSQL function split string
SQL
0 vote294 views1 answer
Soql queries for not contact related account records in salesforce
SQL
0 vote256 views1 answer
Java input type sql date
SQL
2 votes251 views1 answer
Mysql list users on ubuntu
SQL
0 vote273 views1 answer
Max mysql
SQL
0 vote298 views2 answers
Sql having multiple conditions
SQL
7 votes264 views1 answer
Safe update mysql
SQL
5 votes265 views1 answer
How to use rank function in sql
SQL
0 vote268 views1 answer
How convert into in in sql query
SQL
0 vote296 views1 answer
Firebase sql
SQL