or if you want it in the one query:
create table _t(f varchar(50));
select f, case when substr(f, length(f), 1)= substr(f, length(f)-1, 1) then
regexp_replace(f, substr(f, length(f), 1)||'+$', substr(f, length(f), 1))
else f end from _t where length(f)>1;
On 5/8/07, A. Kretschmer <[EMAIL P
am Tue, dem 08.05.2007, um 17:48:47 +0530 mailte Penchalaiah P. folgendes:
>
>
>
>
>
>
>
>
> In a table, a column contains
>
>
>
> Suneelll
>
> Sudhakarr
>
> Vivekk
>
> Ramana
>
>
>
>
>
> But my output is
>
> Suneel
>
> Sudhakar
>
>
In a table, a column contains
Suneelll
Sudhakarr
Vivekk
Ramana
But my output is
Suneel
Sudhakar
Vivek
Ramana
I want a query to get my output like above
Please solve my problem ASAP
Regards
penchal
