select count(*) from <tablename>;

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

Question Posted / ajeet singh

Answer Posted / ajeet singh

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a read write transaction in oracle?

1049

How to use regular expression in pattern match conditions in oracle?

985

Why we use bulk collect in oracle?

987

How to write date and time interval literals in oracle?

992

What is Virtual Private Database in Oracle?

1032

What is the difference between view and materialized view in Oracle?

1103

What is the usage of control file in oracle?

1041

How to increment dates by 1 in oracle?

1017

What is a system tablespace and when it is created?

933

What is analyze command used for?

1024

What does sharding mean?

958

Respected sir, Please send me technical questions related to oracle apps..

1776

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2078

What is a proxy object?

1020

Briefly explain what is literal? Give an example where it can be used?

988