[1666501 views]

[]

Odi's astoundingly incomplete notes

New 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.

posted on 2006-11-30 13:57 UTC in Code | 1 comments | permalink
This only seems to work in PLSQL. A SQL variant still eludes me...

Todd Brook