how to find count rows in table without count function?
Answer Posted / mani
Select max(rownum) from table_name;
Is This Answer Correct ? | 35 Yes | 0 No |
Post New Answer View All Answers
What is meant by joins? List out the types of joins.
How to establish administrator authentication to the server?
What is an external table?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
Briefly explain what is literal? Give an example where it can be used?
How to rename an existing table?
What is a package ? What are the advantages of package ?
What is connection pooling in oracle?
How would you change old and new values in an insert, delete and update triggers?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
What is java oracle used for?
What is the sql query to concatenate column values from multiple rows in oracle?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
What is bulk collect in oracle?
Explain about functional dependency and its relation with table design?