SELECT table_name,status,num_rows AS pocet_radku,avg_row_len pru_del_radku,user_tables.last_analyzed,
LISTAGG(column_name || ' - ' || column_id || ' ' || data_type || '(' || data_length || ')' || ' ' || nullable, '; ')
WITHIN GROUP (ORDER BY column_id ASC) AS seznam_sloupcu FROM USER_TABLES
join user_tab_cols using(table_name)
WHERE table_name LIKE 'IDAS2_SEM%'
GROUP BY table_name,status,num_rows,avg_row_len,user_tables.last_analyzed;