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

Answer Posted / ajeet singh

select count(*) from <tablename>;

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is rowid and rownum in oracle?

541


From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

585


What are privileges and grants?

569


How to list all indexes in your schema?

578


In what script is snap$ created? In what script is the scott/tiger schema created?

2243






What is using clause and give example?

579


What privilege is needed for a user to create tables in oracle?

548


How to find the duplicate rows count from employees table in oracle?

542


What is a sub query? Describe its types?

540


What is flashback in Oracle?

581


How to loop through data rows in the implicit cursor?

537


How to write a left outer join with the where clause in oracle?

623


What is integrity and what is constraint??Explain with example

1695


What is the usage of merge statement?

670


What is a user role in oracle?

613