how to find count rows in table without count function?

Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

how to find count rows in table without count function?

Question Posted / srujana

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

What are set operators?

What is a read write transaction in oracle?

What is tns name?

what are the default admin accounts in Oracle 10g ?

0 Answers MCN Solutions,

what are the things that you consider while creating indexes on partitioning tables?

How to use "while" statements in oracle?

Explain an exception?

How many types of segments in Oracle?

0 Answers MCN Solutions,

What is a initialization parameter file in oracle?

How to install oracle database 10g xe?

How to generate query output in html format?

How to add a new column to an existing table in oracle?

For more Oracle General Interview Questions Click Here

Categories

Oracle General (1809)
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)