how to find count rows in table without count function?

how to find count rows in table without count function?

Question Posted / srujana

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

List out the components of logical database structure of oracle database.

What is a Temporary Segment ?

what is view?

7 Answers Accenture,

What are the extensions used by oracle reports?

difference between truncate and delete ,drop?

What is the minimum client footprint required to connect c# to an oracle database?

How to delete a column in an existing table?

How will you write a query to get a 5th rank student from a table student_report?

How can we Update a table with out using UPDATE command?

Indexes in oracle ?

3 Answers Keane India Ltd, L&T,

How many types of tables are there in oracle?

How to display row numbers with the records?

For more Oracle General Interview Questions Click Here

Categories

Oracle General (1808)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)
Oracle Security (38)
Oracle Forms Reports (510)
Oracle Data Integrator (ODI) (120)
Oracle ETL (15)
Oracle RAC (93)
Oracle D2K (72)
Oracle AllOther (241)