Answer / suraj

select deptno,trunc(avg(sal))as avg from emp group by deptno;

Answer / naresh

select avg(sal) from emp group by deptno;

What does <> mean in database?

0 Answers  

---

What is the use case where we can use stretch database?

0 Answers  

---

Can you explain the 'between' clause?

0 Answers  

---

Is file system a database?

0 Answers  

---

How do you call a stored procedure from jdbc?

0 Answers  

---

---

How many records can a database hold?

0 Answers  

---

Can two oracle blocks have the same address?

0 Answers  

---

what is the location of oracle inventory?

0 Answers  

---

Can I use google sheets as a database?

0 Answers  

---

Explain what is an Exception ?

1 Answers  

---

You loss one datafile and DB is running in ARCHIVELOG mode. You have full database backup of 1 week old and partial backup of this datafile which is just 1 day old. From which backup should you restore this file?

2 Answers  

---

What is meant by database server?

0 Answers  

---