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
- 11928 Views
- I also Faced
- E-Mail Answers
Answer Posted / mail2sentha
select email_id,user_id,substr(email_id,instr
(email_id,'@'),length(email_id)) from mail_id;
i think its correct?
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
Which kind of parameters cannot have a default value in pl sql?
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
Explain commit, rollback and savepoint.
how to show all tables with 'mysql'? : Sql dba
Can there be more than one function with a similar name in a pl/sql block?
what is a constraint? : Sql dba
Can you join a table to itself?
What is an inconsistent dependency?
What is Collation Sensitivity ? What are the various type ?
What is a subquery in sql?
Explain about various levels of constraint.
what is a trigger in mysql? Define different types of trigger. : Sql dba
What are records give examples?
What is a recursive join sql?
What is #table in sql?
