If the base table structure is changed what will happen to join index????

2 Answers  

---

What is the difference between clustered and non-clustered indexes?

0 Answers  

---

why we go for package? what are the advantages of using instead of seperate procuderes or functions

3 Answers   IBM, TCS,

---

What is the use of a view in sql?

0 Answers  

---

What is cold data?

0 Answers  

---

I have a tablle like this. cust acc --------------- a 1 b 2|3 c 4|5|6 I Want below o/p: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 Please any one can you have any ideas share me. I have urgent requirement.

4 Answers   Cap Gemini, MTS,

---

In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop

4 Answers   JDA,

---

What are the different types of sql commands?

0 Answers  

---

When do we create bitmap indexes

2 Answers   CTS,

---

how many triggers are allowed in mysql table? : Sql dba

0 Answers  

---

What is the difference between left join and right join?

0 Answers  

---

What are records give examples?

0 Answers  

---