get size of an empty column in oracle
Posted on 2010-11-17
I have a heap of tables in a new database that are all blank with some changes dripping in every now and again to the design.
I want to get the size in bytes of the columns in each table... not the length of the data in the column as there is none. So I need to add up the size of number, size of nvarchar 100 etc for a table. I can only see Avg row size and functions to give me the size of data contained in the row.
PS.. a nice cursor or something that would take in table names and do this would be cool