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"
- 11 Answers
- 17250 Views
- I also Faced
- E-Mail Answers
Answer Posted / arun a
REPLACECHR( CaseFlag, InputString, OldCharSet, NewChar )
EXAMPLE:
TO_CHAR(REPLACECHR(1,'323-237-2323','-',''))
When CaseFlag is a number other than 0,
the function is case sensitive
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
what are the reports developed in sap bw project and what is the requirement for developing it?
What is the difference between project backlog and product backlog?
What are various etl tools in the market?
Give the benefits of data integration suite?
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
Explain etl?
What are the three tiers in etl?
What are the key benefits of ETL Testing?
What is a mapping?
What are the different etl testing categories as per their function?
What is full load & incremental or refresh load?
What is fact? What are the types of facts?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
how to load the data to fact table?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
