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

Explain what are the type of synonyms?

810


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 ?

1747


How to define a specific record type?

818


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

739


How to resolve the ORA-39133 error in Oracle?

786


Why do we use coalesce function in oracle?

840


what is meant by magic query

1932


can u plz provide me oca sql dumps please i need them

1671


What is the use of file param in imp command?

863


is there a tool to trace queries, like profiler for sql server?

803


How do I use os authentication with weblogic jdriver for oracle and connection pools?

765


What is bind variable in oracle 11g?

771


What is merge statement used for?

749


What is analyze command used for?

785


What are the components of logical database structure in oracle database?

814