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"
- 11 Answers
- 14370 Views
- I also Faced
- E-Mail Answers
Answer Posted / bilas
use TRANSLATE function
select
translate ('323-237-2323','0123456789-', '0123456789')
from table_name;
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
When do we analyze the tables?
what is the meant by Normalization and de-normalization?
what is the use of structures?how many nodes can u create in a structure?
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
what are the concerns of OLTP and DSS systems?
What is tracing level? How many types of transformations supported by sorted input?
Difference between flat files and relational sources?
How many types of transformations supported by sorted input?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
list and discuss two approaches for updation of target table in Informatica and how they are different.
What is a staging area? What is the purpose of a staging area?
how do u identify the changed records in operational data?
How many steps etl contains?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
What is a lookup table in etl?
