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

How many categories of data types in oracle?

787


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

759


How many types of table in Oracle?

836


What are the differences between primary key and unique key?

726


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

790


if you ctreate table identity

2119


Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

1874


What are the differences between date and timestamp in oracle?

784


Why is oracle database so popular?

764


Explain the use of tables option in exp command.

823


How to assign a table row to a record variable?

765


What is an anonymous block?

891


A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

4897


What is merge statement used for?

758


How to open a cursor variable?

792