CODEWITHSUNDEEP
oracle-databasedbms-job
DEVLOGIN
DEVLOGIN

Reputation: 87

Replace ' by ''

I want to use DBMS_JOB.SUBMIT inside a function from package, I use it like this :

if i_iscsv then
    dbms('true');
    DBMS_JOB.SUBMIT(jobno,
                 'DECLARE            
                 BEGIN
                 get('||req||', '''||i_mail||'''); 
                 COMMIT;
                 END;
                 ');

The problem is from V_REQ, because I got a dbms like this :

DECLARE
                 BEGIN
                 get('
    select  distinct
         to_char( date, 'DD/MM/YYYY') date ......

instead of 

DECLARE
             BEGIN
             get('
select  distinct
     to_char(date, ''DD/MM/YYYY'') date

My V_REQ look like this :

 V_REQ := '
    select  distinct
         to_char(date, ''DD/MM/YYYY'') date .....

How can I do to replace ' by '' ?

Thanks

Upvotes: 0

Views: 41

Answers (1)

Arun Palanisamy
Arun Palanisamy

Reputation: 5459

You can use Q'[]' instead of Single Quote

 V_REQ := Q'[select  distinct to_char(v.date_min, ''DD/MM/YYYY'') date]'

See the difference here

Upvotes: 1

Related Questions