Does truncate remove indexes?

0 Answers  

---

Explain correlated query work?

0 Answers  

---

Why do we go for stored procedures?

0 Answers  

---

table :- city name country code abc 11 bcd 22 cde 232 def 33 write a procedure , so that when we give a phone no. eg - 1123456789 - o/p sud be city name = abc if phone no. - 2322345897 , o/p sud be =cde note - bcd and cde city name sud be diff. as dey diff only with th last no. Pls ans. this questnion.

1 Answers  

---

How do I audit the sql sent to the server?

0 Answers  

---

how to insert values like 10:10:00,30:25:00 etc.into table after insert how can i sum the above insert values to get the result as 40:35:00

3 Answers  

---

I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.

4 Answers   GE,

---

What are two virtual tables available during database trigger execution ?

2 Answers  

---

what is the difference between truncate and delete statement? : Transact sql

0 Answers  

---

what is global variable in pl/sql

1 Answers  

---

What is rownum?

0 Answers  

---

What is the largest value that can be stored in a byte data field?

0 Answers  

---