What is the difference between count (*), count (expression), count (distinct ex

What is the difference between count (*), count (expression), count (distinct expression)?

Question Posted / manisha

No Answer is Posted For this Question
Be the First to Post Answer

More Oracle General Interview Questions

What are the basic element of Base configuration of an oracle Database ?

What is the difference between an Oracle Schema and an Oracle Instance?

What is parameterized cursor in oracle?

How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle ( any version ) ?

does Oracle has only one table space?

Explain the use of Merge statement in oracle 11g

Explain the use of owner option in exp command.

I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.

7. Repeat query (7) but also display all clients who have never ordered anything.

What is the difference between 10g OEM and 11g OEM?

What is bulk collect in oracle?

how to use sequence and what use of sequence cache

For more Oracle General Interview Questions Click Here