select count(*) from tab;

how to get count of tables in particular database in Oracle?

Question Posted / abc

Answer Posted / abc

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is oracle instant client?

1020

what is normalisation?what are its uses?

2265

What are the benefits of ordbms?

1081

What is Segment Advisor in Oracle?

1101

Give the constructs of a package, function or a procedure.

1028

What is open database communication (odbc) in oracle?

998

What to do if dba lost the system password?

1162

What is an index associated with a constraint?

1028

Is oracle an open source?

1071

How to retrieve the count of updated rows?

1120

What is where clause in oracle?

1022

How to change system global area (sga) in oracle?

1004

What is Java Pool in Oracle?

1156

How to start instance with a minimal initialization parameter file?

1033

When do we use group by clause in a sql query?

1031