select count(rowid) from emp;

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

Question Posted / sudipta santra

5 Answers
9915 Views
AC, HP, I also Faced
E-Mail Answers

Answer Posted / sudipta santra

select count(rowid) from emp;

Is This Answer Correct ?

23 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is oracle analytical function?

1029

What is literal?

954

What is Data Dictionary Cache in Oracle?

1117

How to connect ms access to oracle servers?

945

Explain the use of compress option in exp command.

965

What are the uses of a database trigger?

926

Does oracle charge for java?

1006

How to work with data objects interactively?

924

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1871

How to manage transaction isolation level?

949

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2002

What is connection pooling in oracle?

911

How can we create the complete backup of data in the oracle.

2092

How can you use check constraints for self referential integrity?

916

What is java oracle used for?

965