What are sql queries used for?

0 Answers  

---

create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms?

2 Answers   Polaris,

---

Do we need to rebuild index after truncate?

0 Answers  

---

What is pessimistic concurrency control? : Transact sql

0 Answers  

---

Is left join inner or outer by default?

0 Answers  

---

---

What is a sql select statement?

0 Answers  

---

i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example empno ename mgr_id 1 john 3 2 paul 3 3 smith 1 4 kevin 1 5 stewart 2 result has to look like this ename manager john smith paul smith smith john kevin john stewart paul can u plz help me out in this.....

8 Answers  

---

Does oracle roll back the transaction on an error?

0 Answers  

---

What is difference between pls_integer and integer?

0 Answers  

---

How to fetch common records from two tables?

1 Answers  

---

What are different sql data types?

0 Answers  

---

What is bulk compiling in pl/sql.?

0 Answers   MCN Solutions,

---