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 the default isolation level in sql server? : Transact sql

962

What are string functions in sql?

1170

How to run pl/sql statements in sql*plus?

1021

How to add a column ‘salary’ to a table employee_details?

953

what is single byte over head in oracle..?

2339

How do I quit sql?

897

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1004

What are joins in sql?

955

what are myisam tables? : Sql dba

951

Why do we need sharding?

936

How can you know that statistics should be updated?

1025

Can we write ddl statements in functions?

1051

how to escape special characters in sql statements? : Sql dba

967

What is a temp table?

948

What is the difference between delete and truncate commands?

975