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...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

How to count the no of records of a table without using
COUNT function?

Question Posted / kart

Answer Posted / kart

using select command
select * from xxx; we will get the no of rows at bottom
if the feedback is unset

then use the plsql with cursor;

select rownum from table; the last value
is the number of records

Is This Answer Correct ?    4 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sql analyzer?

1025

Explain the significance of the & and && operators in pl sql.

1009

How we can update the view?

1050

What is cursor explain with example?

987

What is data modelling in sql?

1020

What is indexes?

1059

Explain the update statement in sql

994

What is pivot table in sql?

1109

What are the different types of a subquery?

1051

What is optimistic concurrency control? : Transact sql

985

Can we use the cursor's to create the collection in PL/SQL?

1028

How do you update a value in sql?

1044

How do I clear the screen in sql plus?

1043

what is sql profiler? : Sql dba

1048

What is dml with example?

1090