What is the difference between delete and truncate statement in sql?

0 Answers  

---

Write a query to genarate target column.Please answer me. Advance Thanks. Src Tgt Q10 Quarter to 2010 Q90 Quarter to 1990 Q80 Quarter to 1980 Q74 Quarter to 1974

5 Answers   Infosys,

---

display null value rows with out using null function?

8 Answers   Infosys,

---

How does cross join work?

0 Answers  

---

What are records give examples?

0 Answers  

---

how can i read files from a pl/sq l program

3 Answers  

---

i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.

2 Answers   IBM, Loginworks, OFSS,

---

how do you tune the slow running queries in oracle db , explain the methodology

0 Answers  

---

what are the differences between char and varchar? : Sql dba

0 Answers  

---

how to achieve this problem?i am having table with two colums like empno,gender. in gender column, i am having records male,female like that .my final output will be male female 5 6

4 Answers   Hexaware,

---

How do you update f as m and m as f from the below table testtable?

0 Answers  

---

What are sql indexes?

0 Answers  

---