how to find count rows in table without count function?

Question Posted / srujana

3 Answers
7025 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 open database communication (odbc) in oracle?

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 is a data dictionary and how can it be created?

0 Answers

How would you go about verifying the network name that the local_listener is currently using?

0 Answers

Give the different types of rollback segments.

0 Answers

What is an oracle database table?

0 Answers

what are indexes..how many types of index's are there and what are they?

7 Answers Green Info Solutions, TCS,

How to use regular expression in pattern match conditions in oracle?

0 Answers

Explain view?

0 Answers

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

0 Answers iFlex,

What is the difference between normal and corelated subqueries?

2 Answers

How can we force the database to use the user specified rollback segment?

0 Answers

For more Oracle General Interview Questions Click Here