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
- 16511 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kumaravelu
substr('TEST@COMPANY.COM',instr('TEST@COMPANY.COM','@')+1)
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / 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 |
Answer / satish
select replace ('323-237-2323','-') from dual
select substr('test@company.com',6,11) from dual
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / kkr
select replace ('323-237-2323','-') from dual
select substr('abc@co.com',-7) from dual
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / venkateswara rao
--Written in sqlserver
declare @num varchar(100) ='323-237-2323'
, @str varchar(100) ='TEST@COMPANY.COM'
, @ind int
set @ind= CHARINDEX('@',@str)
select SUBSTRING(@str,@ind+1,LEN(@str))
print @ind
select REPLACE(@num,'-','')
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / bilas
use TRANSLATE function
select
translate ('323-237-2323','0123456789-', '0123456789')
from table_name;
| Is This Answer Correct ? | 2 Yes | 3 No |
Answer / erqf
2)if findc(emailid,'@','company.com')=0 then
emailid=emailid;
| Is This Answer Correct ? | 0 Yes | 3 No |
my name is amar i want display 1st line A 2nd line M 3rd line A 4th line R in database & informatica
what is data modeling?
In the SEQ generator which property has to be set to generate seq No. when the input data is more than the max limit.
Explain what are the various etl tools in the market?
Explain about enterprise scalability and roi of data integration suite?
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 are the concerns of OLTP and DSS systems?
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
if i have a query as flat file how can we load data to target table
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?
What is partitioning? Explain about round-robin, hash partitioning.
Teradata 
