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
How to change program global area (pga) in oracle?
Explain the difference between a procedure and a function? What do you understand by those terms?
What is Segment Advisor in Oracle?
How can you use check constraints for self referential integrity?
What are the various constraints used in oracle?
How to write date and time literals in oracle?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
What happens if you lost a data file?
How to create a new table by selecting rows from another table?
What do you mean by a tablespace?
How to connect to a local oracle 10g xe server?
How to create an oracle database?
What is enter substitution variable in oracle?
What do you mean by merge in oracle and how can we merge two tables?
Give the various rollback segment states.