sqlplus 10gR2 and later allows you to select from a BLOB. If you use linux, you could convert the hex output to binary with xxd
sqlplus -s scott/tiger <
set pages 0 lin 17000 long 1000000000 longc 16384
select document from emp where ename=user;
Obviously, it could also be a sound, a video or an image !