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 vote142 views2 answers
CREATE OR REPLACE FUNCTION
SQL
17 votes137 views1 answer
Selecting name that contain certain word in sql
SQL
0 vote143 views1 answer
How to make sure two tables have same exact data in sql
SQL
0 vote113 views2 answers
Return the number of records in a single table mysql
SQL
0 vote111 views1 answer
List all functions and procedures in postgres query
SQL
0 vote133 views1 answer
Sql tablo sp
SQL
0 vote113 views1 answer
Inner join distinct
SQL
0 vote95 views1 answer
Lister les index d'une table oracle
SQL
2 votes110 views1 answer
Oracle apex list connected users
SQL
2 votes95 views3 answers
Mysql unix timestamp to date
SQL