without using count(*) and rownum how can we count total
record in a table
Answer Posted / ganesh prasad sial
select sum(1) from emp;
Is This Answer Correct ? | 38 Yes | 2 No |
Post New Answer View All Answers
How to define an oracle cursor variable?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
What is oracle open database communication (odbc)?
How to sort output in descending order in oracle?
How to create a table index?
What would you do with an in-doubt distributed transaction?
How to use attributes of the implicit cursor in oracle?
defination of bitmap index
What happens if you lost a data file?
What do you mean by merge in oracle and how can you merge two tables?
What is an oracle function?
Can sub procedure/function be called recursively?
What are joins, explain all types of joins?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
What is the dynamic sql in oracle?