select count(*) from table name

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

Question Posted / kamala k n

Answer Posted / kamala k n

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a relational database management system?

1120

What is SQL Tuning Advisor in Oracle?

1179

Difference between oracle's plus (+) notation and ansi join notation?

1100

What are the attributes of the cursor?

1004

What is system tablespace?

1097

How to select all columns of all rows from a table in oracle?

1052

What is where clause in oracle?

1031

What to do if dba lost the system password?

1172

Is truncate autocommit in oracle?

1087

How to commit the current transaction in oracle?

1120

How to revoke create session privilege from a user in oracle?

1018

Can a parameter be passed to a cursor?

1126

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2291

What is a system tablespace?

1072

What are the oracle differences between nvl and coalesce

1149