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

3 votes339 views4 answers
Psql list tables in schema
SQL
1 vote796 views1 answer
Athena query timestamp greater than
SQL
3 votes342 views1 answer
Oracle APEX elapsed time
SQL
-1 vote322 views2 answers
How to select the lowest values from table per client sql
SQL
0 vote347 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
0 vote315 views1 answer
Sql not exists
SQL
12 votes354 views6 answers
How to install sqlite3 in python
SQL
0 vote316 views1 answer
How to use lower case in mysql
SQL
4 votes362 views1 answer
What are the data types
SQL
1 vote331 views2 answers
Sql for date greater than
SQL