select * from ALL_TABLES where TABLE_NAME = 'NAME' select count(*) from ALL_TAB_COLUMNS where TABLE_NAME = 'NAME'