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

How to find the duplicate rows count from employees table in oracle?

554


How to drop an existing view in oracle?

571


What are the roles of dba?

614


What are the advantages of oracle 12c?

557


What are the types of trigger in oracle?

576






How to rename an index in oracle?

618


Can we save images in a database and if yes, how?

594


In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

1926


What is merge in oracle?

561


How to use "if" statements on multiple conditions?

723


What is a tns file?

502


What is an oracle database table?

596


What is an oracle?

580


What is the difference between post-database commit and post-form commit?

517


Is insert autocommit in oracle?

606