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 vote347 views1 answer
Change default schema sql server
SQL
0 vote378 views1 answer
SQL query to verify the size of the table
SQL
2 votes380 views2 answers
Sqlalchemy filter or
SQL
0 vote363 views1 answer
Mysql insert into select with recursive
SQL
0 vote363 views1 answer
Sql select random procentage from rows
SQL
0 vote404 views1 answer
Manage Database in MySQL
SQL
6 votes355 views2 answers
Join vs union
SQL
0 vote372 views2 answers
Mysql set foreign_key_checks=0
SQL
1 vote349 views1 answer
Check constraint to check if date greater than todays date
SQL
1 vote370 views1 answer
Partition by sql server
SQL