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 error ora-01000: maximum open cursors exceeded
what are the differences between require and include, include_once and require_once? : Sql dba
Name some usages of database trigger?
What are types of joins?
How can we store rows in PL/SQL using array?
Is sql better than access?
Why do we need pl sql?
What are the datatypes available in pl/sql ?
how to use myisamchk to check or repair myisam tables? : Sql dba
What is consistency?
Why is there a need for sqlcode and sqlerrm variables?
Write the alter statement to enable all the triggers on the t.students table.
What is recursive stored procedure?
What are schema-level triggers?
What is an inner join sql?