SQL help

Hi

Im fairly new to oracle and ive been asked to do something like this.

Define a table (table A) which has one column, but this column contains 1 or more fields concatenated.

Then define another table (table B) which describes the first table in terms of field length and type etc.

EG            TABLE A
 row1        1234567890    (10 chars in the column)

                 TABLE B
row1         field 1      length 4
row2         field 2      length 6

A program would then be written which would look at table B and get the data definations in it and use this to manipulate the data in table A and display it in thenecessary form. Something like this

OUTPUT
part number 1234
amount available 67890

It is this program i need help with. Hope some one can help

marty Received on Thu Jan 07 1999 - 00:00:00 CST