Tuesday, December 29, 2009

To find the number of columns in a Table

select count(*) from all_tab_cols where table_name='student_master' and owner='school';
Also  we can  use,
select count(*) from cols where table_name='student_master';