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 vote150 views1 answer
GROUP BY postgres
SQL
0 vote150 views2 answers
Postgresql gset
SQL
4 votes143 views3 answers
Mysql update with join
SQL
2 votes174 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
0 vote141 views1 answer
Pgsql is not permitted to log in
SQL
3 votes240 views4 answers
Sql interview questions
SQL
0 vote161 views2 answers
Mysql missin expression near on
SQL
0 vote187 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
0 vote143 views1 answer
2020 new year
SQL
0 vote221 views1 answer
Placements hackerrank solution
SQL