Column data in Oracle block
Consider a table having 3 columns,namely EMP(c1,c2,c3)
Using data block header,Oracle identifies that a block containing rows
for EMP table.My doubt in this is,
In the row data of a block,how oracle identifies that this piece of data belong to a particular column(i.e.,column data) of EMP table i.e,how it identifies this portion of data belongs to C1,C2 & C3? Is oracle following any offset mechanism for this classification?Please suggest your answers & views on this question.