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 vote218 views1 answer
Partitioning in oracle-base
SQL
0 vote211 views4 answers
Forenkey code alchemy sql
SQL
0 vote228 views1 answer
Mysql timediff
SQL
5 votes211 views2 answers
Sql conn
SQL
0 vote228 views1 answer
Select milliseconds mysql
SQL
0 vote246 views1 answer
Stratified sampling sql
SQL
0 vote208 views1 answer
Check if table exists oracle
SQL
3 votes212 views5 answers
Mysql get last inserted id
SQL
4 votes252 views1 answer
Sql delete multiple conditions
SQL
0 vote223 views1 answer
Mysql set variable to today's date
SQL