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

What is where clause in oracle?

987

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1021

In what script is snap$ created? In what script is the scott/tiger schema created?

2663

How to load a large xml file?

1009

What is PL/SQL ?

1924

How is it different from a normal table?

979

What are the original export and import utilities?

1073

How to start a specific oracle instance?

1000

What is a trigger and what are its types?

1132

How to generate query output in html format?

1049

What are internal user account in oracle?

953

What is MTTR advisor in Oracle?

1043

Explain the blob datatype?

1027

What is meant by joins? List out the types of joins.

969

In which language oracle has been developed?

1024