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
- 14369 Views
- I also Faced
- E-Mail Answers
Answer Posted / kkr
select replace ('323-237-2323','-') from dual
select substr('abc@co.com',-7) from dual
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
what is Forward,Reverse and Re_engineering?
Explain etl mapping sheets?
Explain do we need an etl tool? When do we go for the tools in the market?
What are the etl testing operations includes?
how do u really know that paging to disk is happening while u are using a lookup transform?
What are the steps involved in etl process?
When do we go for the tools in the market?
if i have a query as flat file how can we load data to target table
What is the difference between Data Warehousing and Data Mining?
What is full load & incremental or refresh load?
Can we create Hierarchies in generic datasources?
what is different between sequential batch and concurrent batch and which is recommended and why?
what is Forward,Reverse and Re_engineering?
What are the different etl testing categories as per their function?
