without using count(*) and rownum how can we count total
record in a table
Answer Posted / sanrai
Select max(rownum) From dual
| Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
What is translate in oracle?
How would you best determine why your MVIEW couldnt FAST REFRESH?
How to define an explicit cursor in oracle?
What are named parameters?
What is the difference between "as" and "is" in an oracle stored procedure?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
what is difference between sql plus and sql*plus? (not sql and sql plus).
Explain about functional dependency and its relation with table design?
what is reindexing?
Can we commit inside a function in oracle?
What is difference between cartesian join and cross join?
how to handle exceptions in post production
State the difference between a primary key and foreign key?
what is the scenario where you take the database to NoArchivelog mode?
How to download oracle database 10g xe?