Explain how exception handling is done in advance pl/sql?

0 Answers  

---

What is cascade in sql?

0 Answers  

---

i have xml source. xml source having lacks of records. i want extract/retrive xml source data using sql query. please tell me how to write query.

4 Answers   TCS,

---

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?

4 Answers   KPIT,

---

How can we optimize a sql query?

0 Answers  

---

How do I view an execution plan in sql?

0 Answers  

---

A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to create hierarchy.

2 Answers   TCS,

---

Show code of a cursor for loop.

0 Answers  

---

List the ways to get the count of records in a table?

0 Answers  

---

how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?

6 Answers  

---

What is trigger point?

0 Answers  

---

Is sql harder than python?

0 Answers  

---