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

5 votes123 views5 answers
Sqlite install python
SQL
0 vote134 views4 answers
How to drop all tables in sql
SQL
4 votes140 views1 answer
SQL find text in SP
SQL
0 vote136 views1 answer
Query params sql insert python f string
SQL
1 vote140 views1 answer
Create table variable in sql stored procedure
SQL
0 vote125 views1 answer
Sql inserted
SQL
0 vote129 views1 answer
Object of class mysqli_result could not be converted to string
SQL
0 vote136 views3 answers
Sql parenthetical expression examples
SQL
5 votes179 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
1 vote134 views1 answer
Increase existing date in sql
SQL