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

2 votes167 views1 answer
Oracle sql concatenate results into string
SQL
27 votes181 views6 answers
Sql update record
SQL
0 vote162 views1 answer
Postgresql regular expression special characters
SQL
0 vote172 views1 answer
Sqlite commands
SQL
6 votes173 views4 answers
Mysql group by month
SQL
0 vote168 views1 answer
Mysql backup certain tables workbench
SQL
0 vote174 views1 answer
Get first 3 letter of department name in sql
SQL
0 vote257 views1 answer
Delet all record statment sql
SQL
-1 vote189 views1 answer
Pl/sql how to delete a trigger
SQL
3 votes231 views1 answer
Sql select second max
SQL