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

Explain the use of rows option in imp command.

1129

How translate command is different from replace?

1135

Explain cascading triggers.

1118

What is merge in oracle?

1095

What is oracle open database communication (odbc)?

1079

How to build data dictionary view an new database?

1044

What to do if the binary spfile is wrong for the default instance?

1106

What is not equal to in oracle?

1047

How to delete an existing row from a table in oracle?

1126

How to create a stored program unit?

1314

What are the advantages of oracle 12c?

1227

Explain what are the type of synonyms?

1182

What is an oracle user account?

1034

Explain compound trigger in oracle?

1086

How to export your own schema?

1047