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 vote325 views1 answer
Create table in dbms cmds
SQL
33 votes303 views6 answers
Change column name in mysql
SQL
0 vote325 views1 answer
Mysql bash execute sql file
SQL
0 vote294 views2 answers
How to update date in oracle
SQL
1 vote315 views1 answer
How to lock table in mysql
SQL
0 vote315 views1 answer
Mysql extract day from date leading zero
SQL
0 vote305 views1 answer
Change redo log file size in mysql 5.6
SQL
2 votes310 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
1 vote285 views1 answer
Column with prefix in sql
SQL
13 votes323 views3 answers
Insert mysql ifile nto database
SQL