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

how to do daily transactions with out sql* loader control file regesterd in apps?

1729

How to resolve the ORA-39133 error in Oracle?

1184

How to get last row id?

1054

What is the difference between substr & instr functions?

1293

When do you get a .pll extension in oracle? Explain its importance

1098

What are oracle functions?

1088

What is memory advisor in Oracle?

1132

What do you mean by merge in oracle and how can we merge two tables?

1095

What are the attributes that are found in a cursor?

1120

Explain user account with reference to oracle.

1029

How to lock and unlock a user account in oracle?

1161

What to do if the startbd.bat failed to start the xe instance?

1126

How to execute the package in oracle?

1135

What is oracle database 10g express edition?

1169

How would you begin to troubleshoot an ORA-3113 error?

2125