display string without having underscore if we send string with underscore

[ausprem2000]

By using Procedure,let display string without underscore,
if we pass string like andhra_pradesh,it has to display andhrapradesh
when procedure is called.

[jamesravid]

The Replace built-in function in oracle serves for u,

select replace('andhra_pradesh', '_',null) from dual;

the above query removes '_' from the input string. You can also ignore the third parameter. that is the following query also returns the same value,

select replace('andhra_pradesh', '_') from dual;

Hope this helps you.