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
- 16979 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 is abap? What are idocs?
Explain about hash partitioning?
What is the difference between Data Warehousing and Data Mining?
What is etl tool in hadoop?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
What is initial load and what is full load?
where is the cache (lookup, index) created and how can you see it.
What is lookup table in etl testing?
dimension object created in oracle can be imported in designer?how?
what is the difference between cardinality and Nullability?
what happens if the info.server doesn't find the session parameter in the parameter file?
What are dimensions?
What are three tier systems in etl?
What are the various tools used in etl?
