how to find count rows in table without count function?

Question Posted / srujana

3 Answers
7110 Views
Oracle, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to find count rows in table without count function?..

Answer / mani

Select max(rownum) from table_name;

Is This Answer Correct ?

35 Yes

0 No

how to find count rows in table without count function?..

Answer / anil kumar

select sum(1) from table_name;

Is This Answer Correct ?

11 Yes

0 No

how to find count rows in table without count function?..

Answer / rajender varma

Select num-rows from user-tables where table-name='emp'

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle General Interview Questions

How can windows applications connect to oracle servers?

0 Answers

write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"

7 Answers British Telecom BT,

What is the difference between translate and replace?

0 Answers

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

0 Answers

What are the different types of database objects?

0 Answers

How do we switch from init.ora file to asp file?

2 Answers

What is bulk load in oracle?

0 Answers

what is the use of composite key constraint?

2 Answers

How to best split csv strings in oracle 9i?

0 Answers

What are the most common interview questions on ETL Testing for experience?

0 Answers

What is an oracle data file?

0 Answers

What are the major difference between truncate and delete?

0 Answers

For more Oracle General Interview Questions Click Here