Answer / gunturajesh

select count(*) from table will give the number of rows in
the table including null values

Answer / bj

select count(1) from <table_name>;

By this also we can count no of rows in a table.

Answer / prakash kumar

select max(rownum)from table_name;
this will also give number of rows in your table

Answer / prabhudatta barick

Please ignore my first answer...

as By default this job runs within a maintenance windows
between 10 P.M. to 6 A.M. week nights and all day on
weekends.

to get the exact record please use this

ANALYZE TABLE <table_name> COMPUTE STATISTICS;

SELECT num_rows
FROM dba_tables
WHERE table_name = '<TABLE_NAME>';

Answer / prabhudatta barick

Automatic Optimizer Statistics Collection
By default Oracle 10g automatically gathers optimizer
statistics using a scheduled job called GATHER_STATS_JOB.

As it gathers table statistics automatically
so no need to gather table statistics before
running this query.

SELECT num_rows
FROM dba_tables
WHERE table_name = '<TABLE_NAME>';

This will give u the total no. of records in a table....

Answer / bolearner

There are 2 ways used to find the row count of any table.

SELECT COUNT(*) FROM EMP;

SELECT TABLE_NAME, NUM_ROWS FROM USER_TABLES WHERE TABLE_NAME='EMP';

Answer / siri

select count(*) from table_name

Answer / amaresh

write this quire "SQL>desc tablename;

What is a join?Explain the different types of joins?

6 Answers   Bank Of India, CitiGroup, Google, ICICI, Saama Tech, SkyTech, TCS,

what is constraining table?

2 Answers  

What are the commands used in sql?

0 Answers  

What is secondary key?

0 Answers  

What is pl sql record in oracle?

0 Answers  

what is check constraint? : Sql dba

1 Answers  

How do I start sql profiler?

0 Answers  

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

0 Answers   Virtusa,

what will be the output: select 1 from emp union all select 2 from emp;

2 Answers   iNautix,

What is sqlca in db2?

0 Answers  

Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.

9 Answers   Oracle,

Why does sql need a server?

0 Answers