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
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
Explain the working of primary key?
What is having clause in sql?
what is the different between now() and current_date()? : Sql dba
How do you define a foreign key?
Why functions are used in sql?
What is bind reference and how can it be created?
What is meant by cursor in sql?
how to fetch common records from two tables? : Sql dba
what are the differences between char and varchar? : Sql dba
How to run sql commands in sql*plus?
How to get each name only once from an employee table?
Can we use insert statement in function?
What is orm in sql?
What is the difference between truncate and drop statements?
What is the basic form of sql query?