how to find count rows in table without count function?
Answers were Sorted based on User's Feedback
Answer / rajender varma
Select num-rows from user-tables where table-name='emp'
| Is This Answer Correct ? | 0 Yes | 0 No |
What is object data modeling?
What is an UTL_FILE.What are different procedures and functions associated with it?
What are the attributes that are found in a cursor?
What do you mean by a database transaction & what all tcl statements are available in oracle?
Explain the use of control file?
How to create a new table in your schema?
How to select all columns of all rows from a table in oracle?
What is cluster Key ?
What is the function of Optimizer ?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
Describe the different type of Integrity Constraints supported by ORACLE ?