Re: PL/SQL Help
From: Ken Denny <ken_at_kendenny.com>
Date: Sat, 09 Mar 2002 01:05:52 GMT
Message-ID: <Xns91CBCEBBC73D9kendenny_at_65.82.44.7>
>: How to convert a string example "MyTable" to "MY_TABLE"?
end loop;
result := result || upper(substr(inp_string,prev_i)); end;
Date: Sat, 09 Mar 2002 01:05:52 GMT
Message-ID: <Xns91CBCEBBC73D9kendenny_at_65.82.44.7>
"MA_IL" <aramraj1_at_yahoo.com> wrote in news:PDai8.2311$702.9034_at_sccrnsc02:
> Hi All >
>: How to convert a string example "MyTable" to "MY_TABLE"?
>: The program should identify the capital letter in the string and
>: prefix it with an "_" (underscrore) and also capitalize others.
>: I really appreciate your help
>: RamRaj
Create or replace
function convert_string(inp_string varchar2)
return varchar2 is
result varchar2(32000);
prev_i integer :=1;
begin
for i in 2..length(inp_string)
loop
if substr(inp_string,i,1) between 'A' and 'Z' then result := result || upper(substr(inp_string,prev_i,i-prev_i)) || '_'; prev_i := i; end if;
end loop;
result := result || upper(substr(inp_string,prev_i)); end;
-- Ken Denny http://www.kendenny.com/ Q: How many programmers does it take to change a light bulb? A: None, it's a hardware problem.Received on Sat Mar 09 2002 - 02:05:52 CET