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
- 16516 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
How many steps etl contains explain with example?
Identifying the bottlenecks in various components of Informatica and resolving them.
what is pmrep command?
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
What are the modules in Power Mart?
What are the different etl testing categories as per their function?
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?
Can u access a repository created in previous version of Informatica?
what is pmrep command?
what are the data modeling tools you have used?(polaris)
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
how do u implement configuration management in Informatica?
What is partitioning? Explain about round-robin, hash partitioning.
what is pmrep command?
How to fine tune mappings?
