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

6 votes102 views1 answer
Postgres get size of database
SQL
1 vote105 views1 answer
How to subtract from the value of a table in sql
SQL
10 votes104 views6 answers
Between sql
SQL
0 vote104 views1 answer
Sqlite select split string
SQL
1 vote99 views1 answer
Adding a default constraint to an existing column in sql
SQL
3 votes145 views1 answer
Oracle nextval insert
SQL
0 vote96 views1 answer
Select all tables linked server sql
SQL
0 vote103 views1 answer
Mysql command line ubuntu
SQL
0 vote104 views2 answers
Cascade syntax in sql
SQL
7 votes114 views2 answers
How to create index mysql
SQL