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
definition of cluster and non-clustered index?
How many categories of data types?
What is data block in Oracle?
What the is the diff between local index and global index. give some example.
Explain the use of show option in imp command.
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
How many types of segments in Oracle?
State all possible different index configurations a table can possibly have?
How to create an initialization parameter file?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
Give the constructs of a package, function or a procedure.
How do we get field detail of a table?
How to turn on or off recycle bin for the session?
What are the uses of synonyms?
Explain enable novalidate constraint.