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 do you mean by stored procedures? How do we use it?
What is the purpose of primary key?
How do I audit the sql sent to the server?
What are sql constraints?
How do we accept inputs from user during runtime?
What plvcmt and plvrb does in pl/sql?
Is pl sql useful?
Which is faster truncate or drop?
How can you create an empty table from an existing table?
what is a composite key ? : Sql dba
What is the difference between inner join and natural join?
What is use of term?
What do you understand by pl/sql packages?
What is dba in sql? : SQL DBA
what are the drivers in mysql? : Sql dba