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 >> Oracle >> Oracle General
  2. Suggest New Category

how to find count rows in table without count function?

Question Posted / rajender varma

Answer Posted / rajender varma

Select num-rows from user-tables where table-name='emp'

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is oracle database client?

974

How to enter a new row into a table interactively?

960

What is not equal to in oracle?

951

Explain the use of analyse option in exp command.

1063

How to select an oracle system id (sid)?

1018

What happens if you set the sga too low in oracle?

1051

Can multiple columns be used in group by in oracle?

926

How to use regular expression in pattern match conditions in oracle?

974

How to find the duplicate rows count from employees table in oracle?

1037

What is the relationship among database, tablespace and data file?

926

How to create a new view in oracle?

1012

What is bulk copy or bcp in oracle?

1043

What is instant client oracle?

972

What happens to the current transaction if a ddl statement is executed?

950

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2199