select count(*) from table;

how do u know the total no of rows in a table?

Question Posted / javid khan

6 Answers
9253 Views
I also Faced
E-Mail Answers

Answer Posted / javid khan

select count(*) from table;

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is an anonymous block?

1323

What are a collation and state the different types of collation sensitivity?

1233

Which is better Oracle or MS SQL? Why?

5029

What happens in oracle commit?

1077

How to use like conditions in oracle?

1111

Can group functions be used in the order by clause in oracle?

1043

What is oracle instant client?

1064

How to pass parameters to procedures?

1085

What are set operators?

1136

Explain the truncate in oracle?

1009

What is sequence?

1136

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2172

What is analyze command used for?

1122

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

2005

What is the difference between substr & instr functions?

1292