how to split the blob byte array and insert in oracle
I am having a string which is of more than lenght 4000 so i am using BLOB datatype as input to get the string.
need to split the blob in oracle and store in the different column
The string is of bytearray i need to strore it in each column based on the byte array.
this will be my input i need to split the above and store it in different columns in a table.
for spliting say
Column1 -1 byte
Table will have corresponding data type
Column1 - number(10,2)
Column2 - Float
Column3 - Float
here Column2 datatype is float but it will always have 3 byte information.
where as Column3 datatype is also float but it will always have 5 byte information.
Say N is Column 120
Please don't create duplicate threads.
You need to mark one of your threads ANSWERED and continue to use the other thread.
I think you did not understand the difference in the heading.....
here i am having it as how to split the blob byte array and insert in oracle
where in the other one it is blob to byte array in java
i am using java as well as Oracle. I am trying to get the result either in Java or in Oracle itself.