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 the command used to fetch the first 5 characters of a string?

0 Answers  

---

Explain the order of sql statement execution?

0 Answers  

---

can we call a procedure from a function?

9 Answers   Mind Tree,

---

Why we use join in sql?

0 Answers  

---

Which sorts rows in sql?

0 Answers  

---

What is the difference between function and procedure in pl/sql?

0 Answers  

---

What is the difference between inner join and outer join?

0 Answers  

---

how to sort records in sql?

3 Answers  

---

write a query that returns first characters of each word in Oracel/Sql pl sql

5 Answers  

---

How many clustered indexes can you have?

0 Answers  

---

what are date and time functions in mysql? : Sql dba

0 Answers  

---