Tuesday, November 27, 2007

Oracle Find or Counts Number Of Row(s) And Column(s) In A Table

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: