What is pl sql package?

0 Answers  

---

Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?

5 Answers  

---

What does t sql mean?

0 Answers  

---

What does seeding a database mean?

0 Answers  

---

Is a view faster than a stored procedure?

0 Answers  

---

What are analytical functions in sql?

0 Answers  

---

How to write a procedure for displying the data in a TREE or (PARENT and CHILD ) relationship , for ex: A is the main project id, for this project B,C,D are sub tasks(sub project id's) for B the sub tasks are e,f,g and for c is h ,i ,j and for d is k,l,m now i need to display the o/p in a TREE fashion pls help me , thanks in advance surendra

2 Answers   Zensar,

---

Write a pl/sql script to display the following series of numbers: 99,96,93……9,6,3?

1 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?

4 Answers   KPIT,

---

How to use distinct and count in sql query? Explain

0 Answers  

---

Initially question was asked to mention the types of indexes. Then asked about BITMAP INDEX and B-Tree Index

2 Answers   Polaris,

---

what are the different tables present in mysql? : Sql dba

0 Answers  

---