Answer / Priyanka Suman

To apply filtering criteria at group level in Oracle, you can use the HAVING clause after the GROUP BY clause. The HAVING clause filters groups based on an aggregate condition. For example:nn```sqlnSELECT department_id, COUNT(employee_id) as number_of_employeesnFROM employeesnGROUP BY department_idnHAVING department_id = 90;n```

How to assign data of the deleted row to variables?

1 Answers  

---

How to use values from other tables in update statements using oracle?

0 Answers  

---

Can select statements be used on views in oracle?

1 Answers  

---

acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account

2 Answers   Polaris,

---

How to rename a column in an existing table?

1 Answers  

---

please explain.. DB architecture ...

1 Answers  

---

can we insert any row to dual table if i got the permission from DBA

5 Answers   HCL, Tesco,

---

Explain the use of indexes option in imp command.

1 Answers  

---

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1 Answers  

---

There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.

2 Answers   Microsoft,

---

Whats the benefit of dbms_stats over analyze?

1 Answers  

---

How many different types of indexes we have in oracle?

24 Answers   IBM, TCS,

---