how to find count rows in table without count function?

Question Posted / srujana

3 Answers
6985 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

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

0 Answers Oracle,

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

0 Answers

What are steps required to ENTER DATA INTO DWH?

2 Answers

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

0 Answers

What are the factors that affect OPTIMIZER in choosing an Optimization approach ?

2 Answers

What is the difference between I and G in Oracle?

0 Answers MCN Solutions,

How to create a new table in oracle?

0 Answers

How does oracle handle read consistency?

0 Answers

Why should I use oracle database?

0 Answers

What are the four Oracle system processes that must always be up and running for the database to be useable?

0 Answers

i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?

2 Answers Microsoft,

What are triggers in oracle?

0 Answers

For more Oracle General Interview Questions Click Here