select count(*) from table name

how do u know the total no of rows in a table?

Question Posted / kamala k n

Answer Posted / kamala k n

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the restrictions on external table columns?

791

How to use "startup" command to start default instance?

736

What are the numeric comparison operations?

849

What is sharded cluster?

712

various types of hints and their usage

2372

Explain what are the advantages of views?

812

How to recover a dropped table in oracle?

801

1) Does oracle have any table which contain all the exceptions and it's code internally?

1510

How to view the data files in the current database?

800

Explain mutating triggers.

784

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

772

What are the differences between primary key and unique key?

726

What is a data lock in oracle?

796

How do I know if oracle is installed on windows?

667

Give syntax for SQL and ORACLE joins.

853