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 votes365 views2 answers
Mysql bidirectional composite primary key
SQL
0 vote339 views1 answer
Drush run sql select
SQL
0 vote363 views1 answer
Sql out file formate
SQL
3 votes313 views1 answer
Delete all content in table mysql
SQL
0 vote324 views1 answer
Sql server select furst day of current year
SQL
0 vote275 views1 answer
Finish transaction sql
SQL
1 vote314 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
0 vote363 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
0 vote352 views1 answer
Selecting Multiple Columns in SQL
SQL
4 votes310 views1 answer
To date oracle with time
SQL