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

1 vote135 views1 answer
Postgresql last element of array
SQL
11 votes199 views1 answer
Oracle export view ddl
SQL
0 vote182 views1 answer
Sql change default collation to utf8
SQL
0 vote198 views1 answer
T sql dynamic top n query
SQL
0 vote179 views1 answer
Allow external access to mysql
SQL
0 vote190 views1 answer
WHERE not regex in SQL
SQL
-2 votes251 views1 answer
Mysql not empty
SQL
5 votes169 views1 answer
List foreign key oracle
SQL
2 votes166 views2 answers
Postgresql date at timezone
SQL
0 vote205 views1 answer
Add column in sql server ubuntu
SQL