Answer / aaa

Group by clause

Answer / chandana

Select avg(sal) from Emp
where avg(sal) >1000;

This gives an error. So, Group Functions(Aggregate) should
not be used in the Where Clause

Answer / manikanta

WE can use group by clause in where clause.
For Ex: SELECT column_name, aggregate_function(column_name)
FROM table_name
WHERE column_name operator value
GROUP BY column_name

We can't use case statement in where clause.

What happens if the imported table already exists?

0 Answers  

---

1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records

1 Answers  

---

What are the different type of Segments ?

2 Answers  

---

Is rowid unique in oracle?

0 Answers  

---

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

0 Answers  

---

Please HELP me its urgent? If i want to EXPORT data from SQL server to ORACLE 11g then how can I replicate data from SQL to ORACLE?

3 Answers  

---

What is Row Chaining ?

3 Answers   Cognizant, CTS,

---

What is schema?

41 Answers   Bodhi Global Services, Cognizant, HCL,

---

Can objects of the same schema reside in different tablespace?

0 Answers  

---

What is oracle open database communication (odbc)?

0 Answers  

---

how to we delete a row using varray

3 Answers   CTC,

---

How a database is related to tablespaces?

0 Answers  

---