1. Categories >> Software >> Data Warehouse >> ETL
  2. Suggest New Category

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 / again kuttu!!

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

what are the concerns of OLTP and DSS systems?

1969

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

980

what is granularity in Data ware House?

1162

how do use session mapping parameters ?(in which transformation)

1438

what is session partitioning?

1459




what are the types in error loging?

1631

What is cube grouping?

557

what are the session parameters? How do u set them?

1514

What is the difference between Data Warehousing and Data Mining?

543

what do u do when DB time takes more?in sap bi

1779

Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance

1802

what is Forward,Reverse and Re_engineering?

1724

Explain about etl data integration software?

482

What are the steps involved in etl process?

513

how do u implement configuration management in Informatica?

4361