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 sql lookup?

0 Answers  

---

What is a primary key called that is made up of more than one field?

0 Answers  

---

How do you truncate?

0 Answers  

---

how can we repair a mysql table? : Sql dba

0 Answers  

---

What is the use of nvl function?

0 Answers  

---

How do I run a sql trace?

0 Answers  

---

what are the join types in tsql? : Transact sql

0 Answers  

---

Explain UNION,MINUS,UNION ALL, INTERSECT?

1 Answers  

---

Why do we use sqlite?

0 Answers  

---

.  have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement. CUST         ACC a            dv b            fg b            bh c            mk c            cl c            so result:- A  B   c dv fg mk    bh cl       so

3 Answers  

---

What is sql server and ase?

0 Answers  

---