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

1 vote352 views1 answer
Table information in sql server
SQL
-1 vote319 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
1 vote404 views1 answer
Mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
SQL
0 vote305 views1 answer
Check mysql password with docker container magento 2
SQL
0 vote316 views1 answer
Composit key in sql
SQL
0 vote346 views1 answer
How to delete duplicate rows in oracle
SQL
0 vote333 views1 answer
Write a query to peint the pattern P(20)
SQL
0 vote330 views2 answers
Identity column in sql server
SQL
0 vote334 views1 answer
Edit a field mysql terminal
SQL
0 vote317 views1 answer
Mysql set boolean default value
SQL