FIND no.of ROWS and COLUMNS in a table

QUERIES to find no.of ROWS and COLUMNS in a TABLE


For ROWS

select table_name,sum(num_rows) from user_tables where table_name='<TABLE_NAME>' group by table_name;

select table_name,sum(num_rows) from all_tables where table_name='<TABLE_NAME>' and owner='<owner_name>'  group by table_name;




For COLUMNS

SELECT count(*) FROM user_tab_columns WHERE table_name = 'FOO'

select count(*) from all_tab_columns where owner='BAR' and table_name='FOO';