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 vote279 views1 answer
Postgresql newline character
SQL
10 votes299 views4 answers
Sql pagination
SQL
0 vote299 views1 answer
Mysql conf.d exampel
SQL
0 vote295 views2 answers
Sql server select first day of previous year
SQL
0 vote326 views1 answer
Mysql command line top 10
SQL
0 vote298 views1 answer
Sqlite higher or equal
SQL
5 votes323 views4 answers
Start postgres server
SQL
0 vote332 views1 answer
Bitmap join index
SQL
0 vote301 views1 answer
Mysql preg replace
SQL
1 vote303 views1 answer
Rermove categories woocommerce sql
SQL