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

Answer Posted / gurudatt

better way is to use the sys.indexes table where it gives the total no rows for each table.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to write date and time interval literals in oracle?

763


What is a cursor and what are the steps need to be taken?

796


What is raw datatype?

837


What is the max number of columns in an oracle table?

727


State and explain the different types of data models?

720


What is dynamic proxy?

772


Is oracle the best database?

711


21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

1819


how to join query for one source type is oracle another source type is sql server ?

2205


What is a synonym? What are its various types?

858


How to count groups returned with the group by clause in oracle?

827


How to list all tables in your schema?

792


How can we find out the duplicate values in an oracle table?

827


How to delete a column in an existing table?

803


hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

1996