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

What does “select count(*) from tab” result?

Answer Posted / umesh h

suppose a table is there with the name tab
then count of rows in that table will be displayed.
else count of all the logical objects under one schema
will be displayed.

Is This Answer Correct ?    3 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is scalar and vector?

1008


What is the difference between a primary key and a unique key?

1057


What are different methods to trace the pl/sql code?

1124


Does sql full backup truncate logs?

1023


What is use of trigger?

936


explain the advantages and disadvantages of stored procedure? : Sql dba

1014


What is compiled query?

1042


What packages(if any) has oracle provided for use by developers?

5813


What are few of the schema objects that are created using PL/SQL?

1043


What is latest version of sql?

1052


1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1598


What is nvl?

1069


What can you do with pl sql?

1097


What is the difference between clustered and non-clustered index in sql?

1017


What is crud sql?

990