I need to provide a projected estimate of Oracle db tables. Essentially my problem is in trying to work out the size of one single row. I have a table which uses the varchar2, integer and date datatypes but I cannot seem to find anywhere how many storage bytes each of these use (with the exception of varchar).
Since you want projected estimate, you have to calculate the size of the data types for the table columns, like
C1 varchar2(21), --size 21 (variable)
C2 number, --size 38 (variable)
C3 date --size 7 (fixed)
A row will occupy c1+c2+c3 size (projected size) but actuall size is what the c1 and c2 is going to occupy depend on the data + the c3.