sqlplus question

Hi Guys

I have fields of datatype long, long Raw and blob.Can u tell me how to read this fields.Assume the field is attachments.

Thanks in Advance
Ravi

set long 2000
select my_long_value from tablename
/

I guess what ravi is asking goes in the same line with my earlier question. I guess he is asking how to read long into a variable. Not just to display in sql*Plus. Am i right ravi ?

Hi Ad

Nope.I want to display the long value at the sql* plus.

Thanks
Ravi