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  

---

How do I pipe the output of one isql to another?

0 Answers  

---

scope of exception handling in plsql

4 Answers   Wipro,

---

What is a field in a database?

0 Answers  

---

How to set up sql*plus output format in oracle?

0 Answers  

---

What is PL/SQL Records?

0 Answers  

---

What has stored procedures in sql and how we can use it?

0 Answers  

---

Can you create a table with Primary Key not as the clustered index.

2 Answers   CGI,

---

Write a simple program on cursors

2 Answers   BirlaSoft,

---

How to display Row Number with Records in Oracle SQL Plus?

0 Answers   MCN Solutions,

---

Which is better stored procedure or query?

0 Answers  

---

what is commit? : Sql dba

0 Answers  

---