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 vote144 views1 answer
Duplicate value unique constraint mysql error
SQL
4 votes145 views1 answer
Create column mysql terminal
SQL
0 vote134 views1 answer
Find and replace query in wordpress\
SQL
0 vote136 views1 answer
Sql select rows with different values in one column
SQL
0 vote163 views1 answer
Example of sql querry result sepapreted by comma
SQL
1 vote151 views1 answer
Psql connect to another database
SQL
0 vote147 views1 answer
Query archive mode
SQL
0 vote138 views1 answer
Mysql concatenate select results
SQL
1 vote209 views1 answer
How to select the nth row in a SQL database table?
SQL
15 votes141 views2 answers
Select where duplicate mysql
SQL