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

8 votes301 views1 answer
How to check mysql version in xampp
SQL
4 votes288 views1 answer
Change nls_date_format
SQL
0 vote294 views1 answer
Mysql check if lowercase
SQL
0 vote293 views1 answer
Get null value in sql
SQL
0 vote301 views1 answer
Postgres clear table
SQL
3 votes269 views1 answer
Insert into table from another table mysql
SQL
7 votes288 views1 answer
Oracle reset sequence
SQL
0 vote280 views1 answer
Mysql date only no time
SQL
0 vote319 views1 answer
Select distinct after join
SQL
0 vote235 views1 answer
Sql count how many times a value appears
SQL