Oracle execute immediate quotes

SELECT 'Simple quote''' FROM dual;		-- Simple quote'
SELECT '''Simple quote''' FROM dual;	-- 'Simple quote'

s_date VARCHAR2(10 BYTE) := '12/02/2021';
EXECUTE IMMEDIATE 'SELECT to_date(''' || s_date || ''', ''DD/MM/YYYY'') FROM dual';

Similar codes

3 votes165 views2 answers
How to list columns for particular tables in postgresql
SQL
0 vote172 views1 answer
Find all tables where column name exists oracle
SQL
0 vote172 views1 answer
Sql delete where x or y or z
SQL
0 vote168 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
0 vote186 views1 answer
How to delete python anywhere mysql database
SQL
1 vote158 views1 answer
Apex run 404
SQL
0 vote182 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
8 votes178 views2 answers
Between operator
SQL
6 votes214 views3 answers
Psql show columns of table
SQL
8 votes183 views4 answers
How to calculate the age from date of birth in python
SQL