How we can find out the total no. of columns present in ANY table?

13.

select count(*) from columns where table_name='ANY';

select count(column) from columns where table_name='ANY';

select count(*) from DB_cols where t_name='ANY';

select count(*) from information_schema.columns where table_name='ANY'

It will search into the dictionary object information_schema.columns with the table name provided by you.