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

1 vote184 views1 answer
Adding indexing on a db model in mysql using sequelize
SQL
0 vote195 views1 answer
Could not assemble any primary key columns for mapped table sqlalchemy
SQL
0 vote236 views1 answer
Kimball data warehouse sql calendar
SQL
0 vote194 views4 answers
How to drop all tables in sql
SQL
4 votes193 views1 answer
Oracle show error line number
SQL
3 votes194 views1 answer
Create a table with an id in mysql
SQL
0 vote194 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
0 vote317 views1 answer
Oracle convert int to date
SQL
0 vote193 views1 answer
Show the colums of table sql
SQL
12 votes206 views4 answers
How to check mysql version ubuntu
SQL