What does “select count(*) from tab” result?

Answer Posted / sudheer

Will display the count of the Tables on the Schema.

Is This Answer Correct ?    22 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between clustered and non-clustered indexes?

601


Is delete faster than truncate?

543


What are different categories of sql commands?

632


How to make a copy values from one column to another in sql?

572


What is the difference between syntax error and runtime error?

612






how to delete an existing column in a table? : Sql dba

550


what does the t-sql command ident_incr does? : Transact sql

595


what is the difference between primary key and unique key? : Sql dba

526


What is a .db file?

538


Does user triggers have entry for trigger with compilation errors?

592


How do you update a value in sql?

547


What are the types of variable use in pl sql?

563


Cite the differences between execution of triggers and stored procedures?

617


What is the difference between functions, procedures, and packages in pl/sql?

482


How will you distinguish a global variable with a local variable in pl/sql?

622