Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

CAN ANY ONE SEND ME THE CODE FOR THE BELOW
1).REMOVE '_' FROM TELE PHONE "323-237-2323" AND SHOULD
DISPLAY OUT PUT AS "323237232"
2). NEED TO ONLY "COMPANY.COM" FROM EMAIL
FILED "TEST@COMPANY.COM"

Answer Posted / again kuttu!!

select substr('12132@dfsaf.com',
instr('12132@dfsaf.com', '@')+1,
length('12132@dfsaf.com'))
from dual

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how would u estimate the size of Aggregator transform data and index cache?

1919


what is the use of structures?how many nodes can u create in a structure?

2166


what is the difference steps for data modeling?

2046


Mention few test cases and explain them?

885


Which transformation we use to convert 'NA' to 'Not Available'

1221


What are the key benefits of ETL Testing?

985


where we cannot use sorter Transformation. if we use then we will not get correct data?

2139


list and discuss two approaches for updation of target table in Informatica and how they are different.

2056


What are various etl tools in the market?

938


In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?

874


What is virtual Data Warehousing?

925


how to load the data to fact table?

2635


Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?

3713


What is data modeling and data mining?

916


what are the session parameters? How do u set them?

1982