Finding No. of columns in table



Here is query to find No. of columns in table.


select table_name, count(column_name)as No_of_Column from USER_TAB_COLUMNS group by table_name order by table_name asc;

 

Comments

Popular Posts