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
Explain the dml?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
What are the major difference between truncate and delete?
Explain the different normalization forms?
Can you create a synonym without having a table?
Why do we need integrity constraints in a database?
How to delete all rows a table in oracle?
What is the difference between a user and a schema in oracle?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
How to create a table index in oracle?
What do you know about normalization? Explain in detail?
What is procedure overloading in oracle?
What do you mean by merge in oracle and how can we merge two tables?
How to rename an index in oracle?
Differentiate between function and procedure in oracle.