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


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

Post New Answer

More Oracle General Interview Questions

What do you know about normalization? Explain in detail?

0 Answers  


The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL

1 Answers   TCS,


In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

0 Answers   IBM,


How do I learn what codesets are available in oracle?

0 Answers  


What is hot backup and logical backup?

0 Answers  






HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT

5 Answers   College School Exams Tests, DELL,


What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?

1 Answers  


How to create a stored procedure in oracle?

0 Answers  


which clause we are not used in where clause?

3 Answers   Semantic Space,


How can we Update a table with out using UPDATE command?

1 Answers  


what is the difference between simple view and complex view?

13 Answers  


How do I uninstall oracle 11g?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)