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"

Answer Posted / again kuttu!!

select substr('12132@dfsaf.com',
instr('12132@dfsaf.com', '@')+1,
length('12132@dfsaf.com'))
from dual

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define slowly changing dimensions (SCD)?

714


SCD2 will work on only dimension tables as well as fact Table?

1069


What is the difference between Data Warehousing and Data Mining?

645


can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?

1814


What are dimensions?

672






Explain about power designer data modeling software?

539


What is lookup table in etl testing?

821


A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?

1909


how do u set partition points in the mapping?

1873


can cubes contain measures ?

1723


where we cannot use sorter Transformation. if we use then we will not get correct data?

1886


What are snapshots? What are materialized views & where do we use them? What is a materialized view log?

735


what make u disappointmnets in u r career

1873


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

2264


What is tracing level?

730