I have a few mainframe table which are to be loaded into an oracle 8.1.5 db.

The structure of the mainframe table is as follows:

LEVEL FIELD
----------------------
2 NSN
3 GROUP CHAR(3)
3 FIN
4 B_NUM CHAR(4)
4 SERIAL_NUM CHAR(3)
2 DESCRIPTION CHAR(45)

So each field is made up of 2 or more parts/fields. How do I represent this in Oracle?

Regards,
Lynn