Explain the components of sql?

0 Answers  

---

What are the types of optimization?

0 Answers  

---

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

1 Answers  

---

what is indexing, searching and user interface?

1 Answers   HCL,

---

How do I run sql profiler?

0 Answers  

---

Can you have multiple SPs with the same name on a database?

2 Answers   CGI, Quest,

---

Can we insert delete data in view?

0 Answers  

---

How collections are improve the performance?

1 Answers   Polaris,

---

how instead of triger is helpful for mutating tables errors handlling ?

2 Answers   Oracle,

---

Why plvtab is considered as the easiest way to access the pl/sql table?

0 Answers  

---

What is embedded sql in db2?

0 Answers  

---

How would you reference column values before and after you have inserted and deleted triggers?

0 Answers  

---