without using count(*) and rownum how can we count total
record in a table
Answer Posted / sudipta santra
select count(rowid) from emp;
Is This Answer Correct ? | 23 Yes | 4 No |
Post New Answer View All Answers
What is an oracle transaction?
How to create a table index?
What do you mean by merge in oracle and how can we merge two tables?
What is an oracle function?
What is tns entry?
Explain an exception and its types?
How to connect to a remote server?
What is a proxy object?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How would you change old and new values in an insert, delete and update triggers?
How to create a stored program unit?
What is an oracle table?
How to create a stored procedure in oracle?
what's query optimization and without use of IN AND Exist can we get another way data from query
How do we get field detail of a table?