Home > IT Answers > Oracle > can u tell me the syantax by which i can select no of rows in a dummy table in oracle 9i?
Software engg
10 pts.
 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?

Software/Hardware used:
ASKED: July 8, 2008  1:52 PM
UPDATED: July 8, 2008  3:31 PM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  July 8, 2008  3:22 pm  by  YuvalShavit   905 pts.
All Answer Wiki Contributors:  YuvalShavit   905 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _