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 vote44 views1 answer
How to get all values in a table mysql in c#
SQL
0 vote46 views1 answer
Mysql group rows with same value
SQL
0 vote52 views2 answers
Sql query print strings and int
SQL
1 vote54 views1 answer
Second last highest id in sql
SQL
0 vote45 views1 answer
Starting mysql shell lampp ubuntu
SQL
3 votes41 views3 answers
Concatenation in sql
SQL
5 votes52 views1 answer
Oracle list days between two dates
SQL
17 votes49 views4 answers
Postgres list users
SQL
0 vote41 views1 answer
Postgresql like
SQL
0 vote46 views1 answer
Oracle current timestamp insert statement
SQL