select count(*) from TableName // To Count The Number of Row(s) in a Particular table
Ex: Select Count(*) from emp;
select count(*) from user_tab_columns where table_name='TABLENAME';
// To Count The Number of Column(s) in a Particular table,
Note :TABLENAME Should be UPPERCASE Letter
Ex: Select count(*) from user_tab_columns where table_name = 'EMP'
No comments:
Post a Comment