select trim(replace('2-3-4','-',NULL)) from dual

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"

Question Posted / kuttu

11 Answers
16531 Views
I also Faced
E-Mail Answers

Answer Posted / kuttu

select trim(replace('2-3-4','-',NULL)) from dual

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is partitioning? Explain about round-robin, hash partitioning.

896

what is the difference between cardinality and Nullability?

3365

What are various etl tools in the market?

938

What are the key benefits of ETL Testing?

986

what is session partitioning?

2040

What is full load & incremental or refresh load?

1155

Give the benefits of data integration suite?

867

what is pmrep command?

2367

Difference between flat files and relational sources?

2223

what happens if the info.server doesn't find the session parameter in the parameter file?

1881

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

1904

what is granularity in Data ware House?

1654

what is dynamic insert?

2132

Explain and compare etl & manual development?

875

What is a lookup table in etl?

1107