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

Answer Posted / mohd akhtar

select sum(1) from emp

Is This Answer Correct ?    4 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you store pictures in a database?

574


What are the set operators union, union all, minus & intersect meant to do?

574


How to save query output to a local file?

568


Explain what are clusters?

624


How to define a variable of a specific record type?

626






you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1570


What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

664


What is where clause in oracle?

538


How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

1627


Explain oracle data types with examples?

587


How to use fetch statement in a loop?

572


Explain user account with reference to oracle.

542


How to start an oracle instance?

581


What privilege is needed for a user to create tables in oracle?

560


In oracle there is column command, how will you explain that?

558