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

0 Answers  

---

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

1 Answers  

---

Question: Below is the table city gender name delhi male a delhi female b mumbai male c mumbai female d delhi male e I want the o/p as follows: male female delhi 2 1 mumbai 1 1 Please help me in writing the query that can yield the o/p mentioned above?

2 Answers  

---

What does pl sql developer do?

0 Answers  

---

What are sql queries used for?

0 Answers  

---

Types of cursors and explanation each of them ?

4 Answers   DELL,

---

how to create a primary key with out creating an index?

9 Answers   TCS,

---

Explain what is a subquery ?

0 Answers  

---

What is sql*plus?

0 Answers  

---

1 SELECT a.field1, b.field2, c.field3, d.field4 2 FROM atable a, atable b, ctable c, dtable d 3 ? 4 ORDER BY 1 What is the minimum number of joins that must be specified on line 3 in the sample code above to properly link the tables? Notice that the table "atable" is aliased twice: once as "a" and once as "b." 1. One join 2. Two joins 3. Three joins 4. Four joins 5. Five joins

6 Answers   Sonata,

---

What is mutating trigger?How to avoid it??

3 Answers   Tech Mahindra,

---

What is sql rowcount?

0 Answers  

---