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 a composite primary key ? : Sql dba

0 Answers  

---

types of exceptions and what is meant by pragma autonomous_transaction ?what is the use.

4 Answers   3i Infotech,

---

what is cursor procedure

1 Answers   iGate,

---

The select into statement is most often used to create backup copies of tables or for archiving records?

0 Answers  

---

What is data control language?

0 Answers  

---

Enlist some predefined exceptions?

0 Answers  

---

How many types of cursors supported in pl/sql?

0 Answers  

---

what are the features and advantages of object-oriented programming? : Sql dba

0 Answers  

---

How do I view a sql database?

0 Answers  

---

what is ref cursor in pl/sql?

3 Answers  

---

how to use like conditions? : Sql dba

0 Answers  

---