What is sql procedures and functions?

0 Answers  

---

need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

2 Answers  

---

How to avoid duplicate records in a query?

0 Answers  

---

What is a mutating table

5 Answers   TCS, Tech Mahindra,

---

Can we use rowid as primary key?

0 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,

---

What is the use of count (*) in sql?

0 Answers  

---

What data types does pl/SQL have?

3 Answers  

---

Is sqlite thread safe?

0 Answers  

---

Why do we use subquery?

0 Answers  

---

What will you get by the cursor attribute sql%found?

0 Answers  

---

When you have to use a default "rollback to" savepoint of plvlog?

0 Answers  

---