mail-id table contains two columns(email_id,userid)
it contains different types of mail-ids,and no of users.
here username length is differ na,(ex-
tamil@yahoo.com,joshua@hotmail.com like)
now i want to fetch the email-ids only starting from '@'
(ex-@gmail.com,@yahoo.com,@hotmail.com
- 5 Answers
- 10386 Views
- I also Faced
- E-Mail Answers
Answer Posted / rk
select substr(mail_id,1,instr(mail_id,'@')-1) from
test_rk_mail
Regards,
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is the benefit of foreign key?
Difference between table function and pipelined function?
write an sql query to find names of employee start with 'a'? : Sql dba
Are pl sql variables case sensitive?
How do I upgrade sql?
Explain ttitle and btitle.
What does the sign mean in sql?
What if we write return in procedure?
how many values can the set function of mysql take? : Sql dba
What are the limitations of sql express?
What is record data type?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
What do you understand by exception handling in pl/sql?
What is an intersect?
What is cartesian join in sql?
