how to find count rows in table without count function?
- 3 Answers
- 5642 Views
- Oracle, I also Faced
- E-Mail Answers
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 explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
What is a nested table and how is it different from a normal table?
What is object data modeling?
What is the string concatenation operator in oracle?
Whats the benefit of dbms_stats over analyze?
How to define an oracle sub procedure?
What are the advantages of oracle?
How to loop through a cursor variable?
How to create tables for odbc connection testing?
What is a view and how is it different from a table?
How to run create database statement again?
How to start instance with a minimal initialization parameter file?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
What are the differences between primary key and unique key?
