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
- 16868 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
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
Explain about enterprise scalability and roi of data integration suite?
What are the different Lookup methods used in Informatica?
What do you understand by active and passive transformations?
explain the methodology of Data Warehousing?(Polaries)
Is hadoop a etl tool?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
what are the data modeling tools you have used?(polaris)
What is cube grouping?
what is granularity in Data ware House?
what is the difference between cardinality and Nullability?
flat filevalidation in informatica
What is partitioning? Explain about round-robin, hash partitioning.
where we cannot use sorter Transformation. if we use then we will not get correct data?
What is a materialized view log?
