table having two columns - entity,zone enity zone pen east pen west pen north pen south pen east pencil east pencil east pencil west I want the output as : entity east west north south pen 2 1 1 1 pencil 2 1 0 0

2 Answers  

---

what are date and time functions in mysql? : Sql dba

0 Answers  

---

display your age in months?

2 Answers  

---

What is the use of nvl function?

0 Answers  

---

What are the different types of constraints?

0 Answers  

---

---

what does myisamchk do? : Sql dba

0 Answers  

---

Can we join more than 2 tables in sql?

0 Answers  

---

how to convert dates to character strings? : Sql dba

0 Answers  

---

How to get the 3rd column(i.e all the data along with the column name)in a table?

2 Answers   Logica CMG,

---

I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.

1 Answers   IBM, Saama Tech,

---

overloading of stored procedure is possible in oracle?

3 Answers   Nelco,

---

How do you sort in sql?

0 Answers  

---