CamelCase in SQL

Example for versions Oracle 11g SQL

This example uses Oracle regular expressions combined with PL/SQL. regex_substr returns a substring of text that is occurrence‘s match to the given regular expression.

declare
 text varchar2(100) := '&user_input';
 word varchar2(100);
 camelcase varchar2(100);
 occurrence number := 1;
begin
 loop
 word := regexp_substr(text, '[[:alpha:]]+', 1, occurrence);
 exit when word is null;
 camelcase := camelcase || initcap(word);
 occurrence := occurrence + 1;
 end loop;
 dbms_output.put_line(camelcase);
end;