What is the average size of a table in ORACLE?
The size of the tables in ORACLE (including number of columns and rows) usually vary depending upon the data being stored on them. Some tables are small, and perhaps have only four or five columns; others are larger, and have many, many columns. The “length” of these tables varies as well, depending upon the number of individual cases recorded for that data element in the table. For example, the SPRIDEN table in BANNER which records the names of persons has numerous columns, and can have many thousands of individual rows or records, depending on the client site. The “width” of each column is likely to be different depending upon the width of the information recorded in each. For example, the column in the SPRIDEN table in BANNER which houses the IDs can be up to 9 spaces in width; other data base columns are shorter, some are longer. It all depends on the nature of the data recorded in that column or field. The order of the columns on a table is entirely irrelevant, as is the order of
