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

2 votes99 views1 answer
How to search table name in stored procedure in sql server
SQL
3 votes134 views2 answers
Brew restart mysql
SQL
0 vote119 views3 answers
Mysqli count down
SQL
0 vote102 views1 answer
How to to get current date in sql
SQL
0 vote100 views1 answer
Postgresql where clause not working
SQL
0 vote104 views1 answer
Postgresql get diff between two dates in Months
SQL
6 votes98 views2 answers
Mysql execute file
SQL
1 vote178 views1 answer
Create new table from old table with data
SQL
0 vote109 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
2 votes118 views1 answer
Sql server current date minus 5 years
SQL