select replace ('323-237-2323','-') from dual select

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 / kkr

11 Answers
17258 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

Please Help Members By Posting Answers For Below Questions

Is apache nifi an etl tool?

1021

what is data modeling?

1951

What is abap? What are idocs?

1023

What are cubes and olap cubes?

1049

How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

1258

What are the differences between sql override and update override?

1147

HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

2086

what are the concerns of OLTP and DSS systems?

2003

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

2088

What are the key benefits of ETL Testing?

1098

How to delete data which is not in source table?

1392

explain the methodology of Data Warehousing?(Polaries)

2367

Mention few test cases and explain them?

981

how to load the data to fact table?

2775

What is lookup table in etl testing?

1232