Question: how to extract blob data from oracle table using sql developer?
Answer: Open the Cart. This is easy, just access it from the View menu. Then drag your objects containing the BLOBs to the Cart. Click the 'Export Cart' button. I recommend these specific options: