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
- 11067 Views
- I also Faced
- E-Mail Answers
Answer Posted / raji_4u
select substr(mail_id,instr(mail_id,'@',1)) from table_name
This works fine.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is the use of sqldataadapter?
Can we update views in sql?
How do you explain an index?
What is the example of procedure?
How do you exit in sql?
What is the difference between function, procedure and package in pl/sql?
what is collation? : Sql dba
Why plvtab is considered as the easiest way to access the pl/sql table?
What types of commands can be executed in sql*plus?
Can we use having without group by in sql?
What are the benefits of stored procedures?
What is cte sql?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
What is fmtonly in sql?
What is a boolean in sql?
