Lets consider table A has 5 columns and i need to insert a row here.
For COL1 - 4, we have the data
and for col - 5 which is a BLOB field and is declared as NOT NULL, we dont have any data from input sources. Our requirement is to insert some dummy values into this BLOB field for now. I have tried many ways to insert dummy fields into this field .. and all in vain.
cast(x'000001' as blob) and so many...
INSERT INTO DATA_BLOB_DUMMY
COL1, COL2, COL3, COL4
Please help me how to get an entry in this table with some value for BLOB?