[1067866 views]

[]

[toggle ads]

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 CET in Code | 1 comments | permalink
This only seems to work in PLSQL. A SQL variant still eludes me...

Todd Brook