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
- 10385 Views
- I also Faced
- E-Mail Answers
Answer Posted / amitabha mandal
select substr(mail_id,instr(email_id,'@'),(length
(email_id,'@') - instr(email_id,'@'))+1) from table_name.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between function, procedure and package in pl/sql?
What are two statement types in sql?
What is a field in a database?
What is the need of a partition key?
How to display Row Number with Records in Oracle SQL Plus?
How to execute a stored procedure?
What is natural join in sql?
Is sqlite good enough for production?
How would you convert date into julian date format?
How do I copy a table in sql?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
What is nosql example?
Why is pl sql needed?
What is cursor and its types?
what does the t-sql command ident_current does? : Transact sql
