select count(*) from table

How do u count no of rows in a table?

Question Posted / siri

Answer Posted / siri

select count(*) from table_name

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

993

Which data type is a composite type?

934

how to run 'mysql' commands from a batch file? : Sql dba

1063

Explain the uses of control file.

994

How to execute a stored procedure?

1036

What is delimiter in pl sql?

992

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

960

Why do we create views in sql?

1055

How do you define a foreign key?

941

What is rownum?

923

What is localdb mssqllocaldb?

1018

Can sql function call stored procedure?

959

What do you mean by rowid?

917

What is dynamic query?

915

what are the different index configurations a table can have? : Sql dba

939