Re: ** HELP ** How to get the number of columns of tables;

You can use the following table(s) to arrive at the number of columns in a table:

ALL_TAB_COLUMNS or USER_TAB_COLUMNS

SQL > SELECT table_name,count(*) 
  2 >   FROM all_tab_columns
  3 >  WHERE owner = 'XYZ' 
  4 > GROUP BY table_name;