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  

---

Explain commit, rollback and savepoint.

0 Answers  

---

Which data type is a composite type?

0 Answers  

---

Can we insert delete data in view?

0 Answers  

---

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

1 Answers   CGI,

---

I Defined SP1, Sp2 (sp=StoreProcedures)In Package Specification but I Implemented Sp1, sp2, sp3, sp4, sp5 then What type of Error You will find????

3 Answers   Infosys,

---

Do prepared statements prevent sql injection?

0 Answers  

---

What are tables and fields in the database?

0 Answers  

---

what is oltp (online transaction processing)? : Sql dba

0 Answers  

---

What do you understand by case manipulation functions?

0 Answers  

---

How do you modify a trigger?

0 Answers  

---

What is Referential Integrity?

3 Answers   IBM,

---