Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 17253 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
What are the three tiers in etl?
how many maximum session supports to multiload in teradata ??
Explain different types of partitioning?
what is the main role of FI on business
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
What is cube grouping?
what is the meaning of upgradation of Repository?
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
What are the differences between sql override and update override?
What are three tier systems in etl?
What are the types of Data Warehouse applications?
Define slowly changing dimensions (SCD)?
how does the server recongnise the source and target databases.Elaborate on this
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
What are the etl testing operations includes?
