how to find count rows in table without count function?

Question Posted / srujana

3 Answers
5638 Views
Oracle, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to find count rows in table without count function?..

Answer / mani

Select max(rownum) from table_name;

Is This Answer Correct ?

35 Yes

0 No

how to find count rows in table without count function?..

Answer / anil kumar

select sum(1) from table_name;

Is This Answer Correct ?

11 Yes

0 No

how to find count rows in table without count function?..

Answer / rajender varma

Select num-rows from user-tables where table-name='emp'

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle General Interview Questions

What is the recommended interval at which to run statspack snapshots, and why?

0 Answers

What are the set operators union, union all, minus & intersect meant to do?

0 Answers

what is the dual table in oracle?

0 Answers

What is an anonymous block?

0 Answers

18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client <clientno> has placed orders to the value of <total value>

2 Answers Wipro,

How to generate query output in html format?

0 Answers

How to name query output columns in oracle?

0 Answers

What do you mean by group by clause?

0 Answers

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

0 Answers

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

0 Answers Oracle,

What privilege is needed for a user to insert rows to tables in another schema?

0 Answers

How to get the Installed Oracle Version Information ?

0 Answers MCN Solutions,

For more Oracle General Interview Questions Click Here