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

Answer Posted / kamala k n

select count(*) from table name

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Compare and contrast between sql and sql server and explain its various functions?

527


Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

1579


What is tns service name?

616


What do you understand by a database object? Can you list a few of them?

604


How to write date and time interval literals in oracle?

569






Explain the difference between replace() and translate() functions in oracle?

576


Can you assign multiple query result rows to a variable?

546


How to drop a tablespace?

568


Give the various rollback segment states.

577


How to drop a stored procedure in oracle?

588


How many types of synonyms in Oracle?

591


Explain integrity constraint?

641


What privilege is needed for a user to insert rows to tables in another schema?

560


How do I learn what codesets are available in oracle?

573


What is oracle open database communication (odbc)?

555