yuvipoy (12/17/2013)
Ok... so where is that information stored and is it stored for every row so you can do variable length columns?
The information will be stored in a BLOB table as byte arrays (junk characters) need to convert it to the original format.
If you put some thing like this in Oracle
Select utl_raw.cast_to_varchar2(utl_raw.CAST_FROM_BINARY_INTEGER(87987)) from dual;
you will be getting the o/p something as
W'
The above is the input for me. i need to read and convert back them.
convert to original format as 87987.
Perhaps this is due to a language barrier problem. Maybe giving Oracle examples will help someone else but it doesn't help me at all. And I also can't help at all unless I know what the field lengths of the data are and what datatypes there will be. And that's only for the fixed fields. There has to be something for each and every row that identifies the starting position for all fields if any variable length data is preset.
Do you have such data? If so, would you mind sharing it with us so we can try to help you with your problem?
--Jeff Moden
Change is inevitable... Change for the better is not.