Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

display string without having underscore if we send string with underscore

This is a discussion on display string without having underscore if we send string with underscore within the Oracle forums, part of the Databases category; By using Procedure,let display string without underscore, if we pass string like andhra_pradesh,it has to display andhrapradesh when procedure is called....

Geeks Talk > Databases > Oracle display string without having underscore if we send string with underscore

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   05-26-2007

ausprem2000 Junior Member   Join Date: May 2007 Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts

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

Sponsored Links

#2 (permalink)   05-28-2007

jamesravid Expert Member   Join Date: Jun 2006 Location: India Posts: 411 Thanks: 15 Thanked 33 Times in 25 Posts

Re: display string without having underscore if we send string with underscore 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. __________________ Cheers, :) James:)

The Following User Says Thank You to jamesravid For This Useful Post:

dhanasweet

Geeks Talk > Databases > Oracle

« Required-interview questions for oracle | Insert data from Db2 to Oracle »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Difference between String.Convert Vs String.ToString	jbanx	C#	6	03-24-2008 01:02 PM
Extract String value	suji	Oracle	1	05-23-2007 02:21 PM
match string using sql query...	psuresh1982	SQL	3	05-14-2007 08:21 AM
String and StringBuffer	ramesh_etta	Java	4	03-31-2007 09:25 AM
String into Long	norman	C and C++	2	07-13-2006 10:51 PM

All times are GMT -4. The time now is 01:44 PM.