how to find count rows in table without count function?
Answers were Sorted based on User's Feedback
Answer / rajender varma
Select num-rows from user-tables where table-name='emp'
Is This Answer Correct ? | 0 Yes | 0 No |
What are the composite date types in oracle?
What is an oracle recycle bin?
How can we find out the current date and time in oracle?
can we pass two out parameters at a time in function?please answer to my question
What is data type in oracle?
Does oracle partitioning improve performance?
How to assign data of the deleted row to variables?
What is user managed backup in Oracle?
what is index?
How to filter out duplications in the returning rows using oracle?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
I have a table that log salary-increase-process have fields: autoid, old_salary, acctno and table EMP: acctno, name, salary I want to list count increase-salary of employees, each have old_salary, new_salary. Help me with SELECT statement, please!