How enter single quote character into dbms_scheduler.set_attribute function parameter?
I need to put the following line
TRUNC(SYSDATE, 'MM') + 15 + 2/24
in the value => parameter. The parameter value needs to be inside single quotes.
If the value has single quote characters in it (like shown above). How do I enter? Using \ to escape does not work, like the following.
begin
dbms_scheduler.set_attribute
(name => 'RECLAIMLOBTABLESPACES',
attribute => 'REPEAT_INTERVAL',
value => 'TRUNC(SYSDATE, \'MM\') + 15 + 2/24');
end;
/
Thanks,
Bill
Tagged:
0