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 the difference between a web-garden and a web-farm? : Sql dba

0 Answers  

What's the difference between inner join and left join?

0 Answers  

What are the indexing methods?

0 Answers  

how can you see all indexes defined for a table? : Sql dba

0 Answers  

Does mysql support pl sql?

0 Answers  

What is cursor and why it is required?

0 Answers  

What is difference between CHAR and VARCHAR2?What is the maximum SIZE allowed for each type?

6 Answers   Saama Tech,

What is java sql package?

0 Answers  

How to raise user-defined exception with custom sqlerrm ?

0 Answers  

What is sql in java?

0 Answers  

a procedure one in two out parameters i am waiting it in a sql query can i get the output

1 Answers  

Dear All, Question for this Week Find out possible error(s) (either at compile time or at runtime) in the following PL/SQL block. State the reason(s) and correct the errors. Declare Cursor C1 is select ename, sal, comm from emp; Begin For i in C1 Loop If i.comm between 299 and 999 then Dbms_output.put_line(i.Ename || ‘ ** Good Commission’); Elsif i.comm > 999 then Dbms_output.put_line(i.Empno || ‘ ** Very Good Commission’); close C1; Else Dbms_output.put_line(i.Ename || ‘ ** ’ ||nvl(i.comm,‘O’)); End if; End Loop; End;

7 Answers   Accenture,