Answer Posted / bolearner
There are 2 ways used to find the row count of any table.
SELECT COUNT(*) FROM EMP;
SELECT TABLE_NAME, NUM_ROWS FROM USER_TABLES WHERE TABLE_NAME='EMP';
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the advantages of pl sql?
Explain how can you save or place your msg in a table?
What is consistency?
Can we use delete in merge statement?
What is minus?
What are the dml statements?
what are the different functions in sorting an array? : Sql dba
What is sql performance tuning?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
What is full join in sql?
Write a query to find the names of users that begin with "um" in sql?
What operators deal with null?
what are the different type of normalization? : Sql dba
What is dynamic query?
Describe types of sql statements?