select count(1) from <table_name>; By this also we can count no of

How do u count no of rows in a table?

Question Posted / bj

Answer Posted / bj

select count(1) from <table_name>;

By this also we can count no of rows in a table.

Is This Answer Correct ?

19 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How many types of cursors supported in pl/sql?

1177

How many joins in sql?

998

Which normal form is best?

948

What is coalesce in sql?

1049

What is before trigger?

997

What does cursor do in sql?

1012

What is pl sql record in oracle?

1021

Explain the components of sql?

1053

Is primary key always clustered index?

1013

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

1005

What is a .db file?

980

What is the difference between between and in condition operators?

999

how to present a past time in hours, minutes and seconds? : Sql dba

1005

How does a self join work?

1101

what are the differences between char and varchar? : Sql dba

1066