select sum(1) from table

how to find count rows in table without count function?

Question Posted / anil kumar

Answer Posted / anil kumar

select sum(1) from table_name;

Is This Answer Correct ?

11 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to pass parameters to procedures?

555

How do I use os authentication with weblogic jdriver for oracle and connection pools?

577

How to create a table index in oracle?

662

What is meant by an index?

629

Explain the difference between a procedure and a function?

561

What is SQL access advisor in Oracle?

634

How to get execution statistics reports on query statements?

572

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1676

What is the Tune Query

1847

How to create a new view in oracle?

622

What is the meaning of recursive hints in oracle?

532

What is a data lock in oracle?

615

Explain a segment?

621

What is proxy method?

545

Explain what are synonyms used for?

612