How to Estimate maximum size of new column in a table and check actual size of existing column in a table in ORACLE - Mohammad Nazmul Huda
Rules of thumbs for column size calculation(Part-1) - YouTube
oracle - pl/sql cursor that calculates the average and update the column and ordering the records at the same time by that sum calculated average - Stack Overflow