how do u know the total no of rows in a table?

Answer Posted / kamala k n

select count(*) from table name

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to write date and time literals in oracle?

564


Explain oracle instance.

690


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

541


What do you mean by a deadlock?

527


How to check the server version in oracle?

620






What is the use of oracle?

568


What to do if dba lost the system password?

613


State and explain about oracle instance?

560


In which language oracle has been developed?

661


how may join possible between (requisition with purchase order)

1712


Explain a synonym?

614


How to view the tablespaces in the current database?

566


How many types of database triggers exist?

590


How does the on-delete-cascade statement work?

619


How to delete all rows a table in oracle?

633