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

how to find count rows in table without count function?

Question Posted / rajender varma

3 Answers
6882 Views
Oracle, I also Faced
E-Mail Answers

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 is an oracle cursor variable?

1020

How can we find out the current date and time in oracle?

1043

How can I introduce multiple conditions in like operator?

929

What is oracle open database communication (odbc)?

970

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

946

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1024

Explain the difference between a procedure and a function?

1097

Explain the use of ignore option in imp command.

984

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1824

Explain oracle left join with an example?

959

How to drop an index in oracle?

1026

How to define an explicit cursor in oracle?

995

Which are the five query types available in oracle?

910

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1867

What is oracle analytical function?

1042