What is the difference between DELETE, TRUNCATE, and DROP?

3 Answers  

---

if table named a is there and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time

1 Answers  

---

What is self-join and what is the requirement of self-join?

0 Answers  

---

what are the features and advantages of object-oriented programming? : Sql dba

0 Answers  

---

How do I delete a trigger?

0 Answers  

---

What is normalization? How many normalization forms are there?

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 does one use sql*loader to load images, sound clips and documents? : aql loader

0 Answers  

---

ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.

2 Answers  

---

How can the performance of a trigger be improved?

0 Answers  

---

How many types of keys are there in sql?

0 Answers  

---

What is a constraint? Tell me about its various levels.

0 Answers  

---