By using Procedure,let display string without underscore,
if we pass string like andhra_pradesh,it has to display andhrapradesh
when procedure is called.
By using Procedure,let display string without underscore,
if we pass string like andhra_pradesh,it has to display andhrapradesh
when procedure is called.
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.:)