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

0 vote249 views1 answer
Wordpress sql change site url
SQL
0 vote259 views1 answer
Get cpu details sql
SQL
0 vote285 views1 answer
List in one column mysql
SQL
0 vote290 views1 answer
Insert using condition postgres
SQL
1 vote257 views1 answer
Sql bitwise operators
SQL
0 vote266 views1 answer
Ksql quickstart docker
SQL
0 vote246 views1 answer
Sql cross apply vs join
SQL
0 vote299 views1 answer
Oracle pl/sql check if file exists
SQL
2 votes273 views1 answer
Scaffold npgsql net core
SQL
4 votes294 views1 answer
Sql delete multiple conditions
SQL