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  

---

I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.

7 Answers   MTS,

---

In a distributed database system, can we execute two queries simultaneously?

0 Answers  

---

Find out the 3rd highest salary?

51 Answers   BirlaSoft, DAC, Silvia Infotech, Sutra Infotech,

---

Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not having fixed count in between of string. I want the output to have string with one dot between. I.e. A.B.C.D.E.F

6 Answers   IBM,

---

What are the different tcl commands in sql?

0 Answers  

---

What is the difference between view and stored procedure?

0 Answers  

---

How does index help in query performance?

0 Answers  

---

How to copy a table in another table with datas?

9 Answers  

---

Why do we use set serveroutput on?

0 Answers  

---

How do I clear the screen in sql plus?

0 Answers  

---

What is the difference between having and a where in sql?

0 Answers  

---