Odi's astoundingly incomplete notesNew entries | Code
Oracle: convert LONG to VARCHAR
Seems hard, but is simple (at least with 10g):
mystring := substr(mylong, 1);With older Oracle versions your milage may vary.
This only seems to work in PLSQL. A SQL variant still eludes me...