select sum(1) from emp;

without using count(*) and rownum how can we count total
record in a table

Question Posted / ganesh prasad sial

Answer Posted / ganesh prasad sial

Is This Answer Correct ?

38 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to see free space of each tablespace?

967

How to use "in" parameter properly?

1002

What is oracle sid?

887

What is the maximum number of triggers that can be applied to a single table?

954

How to call a stored function in oracle?

950

How to connect to a local oracle 10g xe server?

935

What is redo log?

1004

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

967

What is partitioned table in Oracle?

1104

How do we represent comments in oracle?

1000

Which are the five query types available in oracle?

895

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2248

How to manage transaction isolation level?

949

How many types of tables supported by oracle?

1018

What is the purpose of save points in oracle database?

1004