What are the types of SQL Statement?

3 Answers  

---

query to retrive the employees whose sal is greater than avg sal

10 Answers   TCS,

---

What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..

1 Answers   Metric Stream, Polaris,

---

What is trigger types in sql?

0 Answers  

---

Explain the commit statement.

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  

---

What is the default isolation level in sql server? : Transact sql

0 Answers  

---

How many types of triggers exist in pl/sql?

0 Answers  

---

How to create a menu in sqlplus or pl/sql?

0 Answers  

---

What is a package ? What are the advantages of packages ?

2 Answers   Symphony,

---

How to combine two stored procedures in sql?

0 Answers  

---

What are expressions?

0 Answers  

---