What are the basic techniques of indexing?

0 Answers  

---

What is partition by in sql?

0 Answers  

---

How exception is different from error?

0 Answers  

---

What is information schema in sql?

0 Answers  

---

What is nosql example?

0 Answers  

---

While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?

2 Answers   HSBC,

---

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

0 Answers  

---

What is the basic structure of PL/SQL ?

6 Answers  

---

What are the usages of sql?

0 Answers  

---

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

2 Answers  

---

If you have to declare procedure1,procedure2 in package specification and if you have to declare procedure1,procedure2 and procedure3 in package body? is it compilation or not and execute or not? what type of error is given please

1 Answers  

---

Explian rowid, rownum? What are the psoducolumns we have?

0 Answers  

---