Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11989 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 purpose of primary key?
Explian rowid, rownum?
What are sql procedures?
Is inner join same as self join?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
Which are the different character-manipulation functions in sql?
What are the three pl sql block types?
What are few of the schema objects that are created using PL/SQL?
How to place comments in pl/sql?
how to shutdown mysql server? : Sql dba
Describe sql comments?
how to write date and time literals? : Sql dba
What is db journal file?
what is sub-query? : Transact sql
What is trigger types of trigger?
