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

Answer Posted / rajasekar

Select count(*) from table

Is This Answer Correct ?    13 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to use "in" parameter properly?

623


Explain the function of optimizer in oracle?

604


What is merge in oracle?

569


How to export data with a field delimiter?

585


How do we get field details of a table?

554






i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

1809


how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

1833


I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

1866


How many types of tables are there in oracle?

582


What is oracle used for?

540


What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

622


What is an oracle tablespace?

610


What is a cursor and what are the steps need to be taken?

603


Explain the difference between replace() and translate() functions in oracle?

587


What is key preserved table?

570