select count(rowid) from emp;

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

Question Posted / sudipta santra

Answer Posted / sudipta santra

Is This Answer Correct ?

23 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is the use of aggregate functions in oracle?

1026

What is an external table?

1027

Does facebook use oracle?

1039

What is the meaning of recursive hints in oracle?

1046

What is literal?

1015

What are triggers in oracle?

1043

How do I call oracle stored procedures that take no parameters?

1123

How to delete all rows a table in oracle?

1072

Explain oracle instance.

1185

how do u setup a replication site?

1991

How do I spool to a csv formatted file using sqlplus?

1039

what is the scripts in data base?

2160

what is dynamic SGA and static SGA

4422

what is a Nested Loop join?

2120

Use of an integrity constraint is better to validate data. Explain

1044