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

Answer Posted / rajasekar

Select count(*) from table

Is This Answer Correct ?    13 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In which language oracle has been developed?

844


What is a trace file and how is it created in oracle?

759


What do you mean by a deadlock?

738


How to unlock the sample user account in oracle?

723


Is oracle a programming language?

750


How do I limit the number of rows returned by an oracle query after ordering?

879


What is system tablespace?

839


How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1695


How to connect to a local oracle 10g xe server?

721


What is the sid in oracle?

703


Can we use bind variables in oracle stored procedure?

688


What are the data types in oracle?

769


How to rename an existing table?

789


What are the limitations of check constraint?

774


What is tns entry?

807