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 vote327 views1 answer
Mysql error codeigniter
SQL
0 vote362 views1 answer
Shows all databases created by user in ms sql
SQL
11 votes356 views1 answer
Sql query to find duplicates in column
SQL
0 vote335 views1 answer
Price-colour
SQL
0 vote343 views1 answer
How to drop a trigger in postgresql
SQL
3 votes326 views2 answers
Oracle for loop
SQL
13 votes378 views4 answers
Mysql remove foreign key constraint
SQL
2 votes374 views6 answers
Mysql change timezone
SQL
2 votes363 views1 answer
How to delete columns in sql
SQL
0 vote354 views4 answers
What is unique key in sql
SQL