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
Define slowly changing dimensions (SCD)?
SCD2 will work on only dimension tables as well as fact Table?
What is the difference between Data Warehousing and Data Mining?
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
What are dimensions?
Explain about power designer data modeling software?
What is lookup table in etl testing?
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?
how do u set partition points in the mapping?
can cubes contain measures ?
where we cannot use sorter Transformation. if we use then we will not get correct data?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
what make u disappointmnets in u r career
Identifying the bottlenecks in various components of Informatica and resolving them.
What is tracing level?