How do I send sql query results to excel?

0 Answers  

---

Which query operators in sql is used for pattern matching?

0 Answers  

---

What is Temp Table and type of temp table?

1 Answers   HP, SLK,

---

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  

---

how to find the First and Last Observation from the table: Ex: OBS Name Sal Ans like: OBS Name Sal 105 E 5000--> 105 E 5000 102 B 2000 104 D 4000 103 C 3000 101 A 1000--> 104 D 4000

4 Answers  

---

---

Does inner join return duplicate rows?

0 Answers  

---

Can we use update in sql function?

0 Answers  

---

What does 0 mean in sql?

0 Answers  

---

What is trigger and stored procedure in sql?

0 Answers  

---

Explain the uses of a database trigger?

0 Answers  

---

Is primary key clustered or nonclustered?

0 Answers  

---

What are the benefits of pl sql?

0 Answers  

---