Oracle Database Discussions

Hi everyone,

I have a portion of PL/SQL code that dynamically generates insert statements.
Since I'm a perfectionist, I would like the code to be formatted entirely in lower case, but some pieces need to be preserved in the original format (otherwise the code doesn't work properly). I'll give you a simplified example.

declare
  v_string varchar2(100);
begin
  v_string := 'insert into my_table (col1, col2) values (1, ''ORACLE'')';
  v_string := lower(v_string);
  dbms_output.put_line(v_string);
end;

As you can verify, this piece of code modifies the entire content of the string and does not preserve the internal single quoted string capitalized ('ORACLE').

Any ideas on how I can do it?

Thanky you.