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
16505 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

Is hadoop a etl tool?

875

What are dimensions?

983

Give the benefits of data integration suite?

859

What are snapshots?

925

give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.

2302

what is session partitioning?

2032

what is session partitioning?

1821

How many types of transformations supported by sorted input?

1129

Identifying the bottlenecks in various components of Informatica and resolving them.

1868

Difference between flat files and relational sources?

2216

What is meant by incremental load?

1012

Which transformation we use to convert 'NA' to 'Not Available'

1217

What is initial load and what is full load?

899

what is granularity in Data ware House?

1652

What is a mapping, session, worklet, workflow, mapplet?

914