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

7 votes123 views1 answer
Mysql load data infile csv
SQL
2 votes155 views2 answers
Created at and updated at in mysql
SQL
0 vote170 views2 answers
Mysql missin expression near on
SQL
0 vote208 views1 answer
Updating database in sql
SQL
0 vote163 views1 answer
Mysql average from two table
SQL
0 vote182 views1 answer
Edit shchima table in sql
SQL
6 votes141 views5 answers
Get current date sql
SQL
1 vote149 views1 answer
Loading local data is disabled mysql
SQL
0 vote165 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
2 votes179 views4 answers
Mysql select into new table
SQL