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

22 votes228 views4 answers
Date format mysql
SQL
1 vote218 views1 answer
Where date = max(date) in sql
SQL
0 vote224 views1 answer
Pgadmin save data greyed out
SQL
10 votes208 views4 answers
Fetch first 5 characters of the string in sql
SQL
0 vote229 views1 answer
See the structure of a table mysql
SQL
0 vote228 views1 answer
How to get number of months between 2 dates sql server
SQL
0 vote206 views1 answer
Varchar format not case sensitive sql
SQL
1 vote193 views1 answer
Mysql view command
SQL
1 vote203 views1 answer
Stop mysql server mac
SQL
0 vote219 views1 answer
Print mysql
SQL