I have a requirement to escape any single quote in given string.
I am trying to test the following example.
Can you give me the correct syntax to achieve this.
Here is an example:
declare
v_sql varchar2(100);
begin
v_sql := 'Iam here';
dbms_output.put_line('string is '||q'[v_sql]');
end;
Any help would be appreciated,
Kindest Regards,
Naga