how to find count rows in table without count function?

Answer Posted / rajender varma

Select num-rows from user-tables where table-name='emp'

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What happens if you lost a data file?

580


How to define a sub function?

664


Explain alias?

711


How to turn on or off recycle bin for the instance?

609


What is the difference between a user and a schema in oracle?

561






what are the advantages of running a database in archive log mode?

1731


Explain the difference between a procedure and a function? What do you understand by those terms?

622


How to connect to a local oracle 10g xe server?

533


Is oracle a programming language?

564


How do you find current date and time in oracle?

590


What is the relation of a user account and a schema?

613


What happens to the current transaction if the session is ended?

526


What is the meaning of recursive hints in oracle?

532


How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2393


What is the difference between truncate & delete command?

615