select count(rowid) from emp;

without using count(*) and rownum how can we count total
record in a table

Question Posted / sudipta santra

Answer Posted / sudipta santra

Is This Answer Correct ?

23 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is the sql query to concatenate column values from multiple rows in oracle?

1056

What is the meaning of recursive hints in oracle?

1046

How to convert characters to numbers in oracle?

1065

How to update values on multiple rows in oracle?

1034

How to call a stored function in oracle?

1018

what are steps for interface? where is exchange rate defined in which table?

2158

How to bring a tablespace online?

1079

Difference between inner join vs where ?

1033

Explain integrity constraint?

1161

State all possible different index configurations a table can possibly have?

1001

How to load data from external tables to regular tables?

1062

What is the difference between "as" and "is" in an oracle stored procedure?

991

How view is different from a table?

1035

How to run create database statement?

1032

How to experiment a data lock in oracle?

1056