Select Count(*) From User

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

Question Posted / nirav21686

Answer Posted / nirav21686

Select Count(*) From User_Tables

Is This Answer Correct ?

16 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to assign query results to variables?

1043

What are the parameters that we can pass through a stored procedure?

1058

Where do you use decode and case statements?

985

What are the differences between char and nchar in oracle?

1081

Can you tell me how to add new column in existing views?how?How is possible?

1431

What is the use of file param in imp command?

1159

What is the sid in oracle?

961

What is meant by an index?

1133

What are the major difference between truncate and delete?

1046

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2821

What is a sub query? Describe its types?

1011

Explain about your project and its relation to the current job position you are applying to?

1000

Why is oracle database so popular?

987

Explain the dml?

972

what are steps for interface? where is exchange rate defined in which table?

2147