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

2 votes78 views1 answer
Oracle current date without time
SQL
0 vote113 views1 answer
Mysql set column equal to another automatic
SQL
0 vote73 views1 answer
Procedures and functions in pl/sql
SQL
0 vote154 views1 answer
Sql count matching group by
SQL
0 vote139 views1 answer
How to to get time in sql
SQL
-1 vote116 views5 answers
Online sql to linq generator
SQL
0 vote120 views1 answer
Will graphql replace sql
SQL
20 votes119 views5 answers
Mysql reset auto increment to 1
SQL
0 vote108 views1 answer
Show specific events on mysql
SQL
0 vote115 views1 answer
Check index sql server
SQL