An *easy* way to look at data in BLOB 1

[SuperMallen]

There are several columns in my database which or of type LONG RAW or BLOB. I would like a simple way to view the data within these columns, but Oracle seems to stimey me at every turn. There are plenty of ways to get data *into* these fields, but no real good ways of getting out such that I can see it, either on the command line, through SQL*Plus, or any other handy app (like TOAD).

Who out there has the magic that'll let me say, "Hey, that BLOB right there, what has it got in it?"

 

[toadhead]

Hi,
if you change your setting in toad through - view - options - data grids - data - and check the 'popup memo editor on double click' option, then you can select any lob cloumn with data in it and double click. This will open another window with the option to save to file. Do that and then go to the operating system where you saved it and you should be able to open the file.
A bit round about - but it works for me !!

 

[SuperMallen]

Thanks ToadHead! For those of you who don't quite see the option, look at the top, left-hand part of the dialog box and you'll see the "Save to file" button, hidden away. This works great, though, thanks again!