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 is primary key? : Sql dba
What view means?
What is full join?
How do you select unique values in sql?
What are the parts of a sql statement?
What is materialized view in sql?
Do we need commit after truncate?
How many scalar data types are supported in pl/sql?
Can we use loop in sql?
What is the process of copying data from table a to table b?
what is the difference between $message and $$message? : Sql dba
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
What is difference between pls_integer and integer?
Which command is used to delete a trigger?
What is the advantage of index in sql?