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
- 16981 Views
- I also Faced
- E-Mail Answers
Answer Posted / bilas
use TRANSLATE function
select
translate ('323-237-2323','0123456789-', '0123456789')
from table_name;
| Is This Answer Correct ? | 2 Yes | 3 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 are the key benefits of ETL Testing?
What is etl tool in hadoop?
Can u access a repository created in previous version of Informatica?
What are the types of Data Warehouse applications?
When do we go for the tools in the market?
can cubes contain measures ?
What is tracing level and what are the types?
what is data modeling?
Explain about hash partitioning?
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
Explain the use lookup tables and Aggregate tables?
What is the difference between round-robin partitioning and hash partitioning?
what are the reporting tools and difference between them?
how many maximum session supports to multiload in teradata ??
