can u tell me the syantax by which i can select no of rows in a dummy table in oracle 9i?
Oracle 9i
can u tell me the syantax by which i can select no of rows in a dummy table in oracle 9i? Question
Oracle 9i
can u tell me the syantax by which i can select no of rows in a dummy table in oracle 9i? 
Subscribe to Alerts! Get questions and answers delivered to your Inbox.
Answer Wiki (Improve, edit or add to this answer)
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
The standard SQL approach would be "select count (*) from tableName". Some DBs maintain internal counters that return this result as a simple lookup rather than having to actually count each individual row. Without knowing anything on Oracle 9i specifically, I would guess that it's one of those DBs.
Browse more Questions and Answers on Oracle.
Looking for relevant Oracle Whitepapers? Visit the SearchOracle.com Research Library.
