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?

Answer Posted / mani

Select max(rownum) from table_name;

Is This Answer Correct ?    35 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different types of record groups in oracle? Explain each of them

969


22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

1952


What is oracle open database communication (odbc)?

957


How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2051


What is the difference between 10g OEM and 11g OEM?

916


How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1005


Can you create a synonym without having a table?

976


What is connection pool in oracle?

926


1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1908


how to handle exceptions in post production

1358


What is the difference between translate and replace?

1010


How to put more than 1000 values into an oracle in clause?

969


What are the limitations of check constraint?

960


How to write date and time interval literals in oracle?

964


How do I use os authentication with weblogic jdriver for oracle and connection pools?

995