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
6979 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 is an oracle?

how do u know the total no of rows in a table?

How are the index updates?

What are the differences between blob and clob in oracle?

How to define a variable of a specific record type?

How to define a cusotmer as a supplier in ORACLE R12

0 Answers Intelligroup,

How to create index-by table in oracle?

What is set verify off in oracle?

What is the fastest query method to fetch data from the table?

What is an oracle recycle bin?

Explain mutating triggers.

Difference between varchar and varchar2 data types?

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)