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
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?
is pronounced ree-bar and is a Modenism for R
First step towards the paradigm shift of writing Set Based code: Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Helpful Links:
How to post code problemsHow to post performance problemsForum FAQs