select count(rowid) from emp;

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

Question Posted / sudipta santra

5 Answers
10153 Views
AC, HP, I also Faced
E-Mail Answers

Answer Posted / sudipta santra

select count(rowid) from emp;

Is This Answer Correct ?

23 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

why dont we assign not null constraint as table level constraint.

2735

How many types of auditing in Oracle?

1033

What are oracle functions?

1030

How to do a full database export?

1106

Write a syntax for update query in oracle?

1032

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1947

How do you bind variables in oracle?

980

What is difference between cartesian join and cross join?

1088

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2323

How to insert multiple rows with one insert statement in oracle?

1083

What is the difference between formal parameters and actual parameters?

1085

How to store pictures on to the database?

973

How to resolve the ORA-39133 error in Oracle?

1110

Give the different types of rollback segments.

1030

What is analyze command used for?

1070