Home » RDBMS Server » Server Administration » LONG to CLOB datatype conversion?
LONG to CLOB datatype conversion? [message #369998] Thu, 23 November 2000 21:41 Go to next message
Leigh Satchell
Messages: 1
Registered: November 2000
Junior Member
Can anyone tell me how to load data from a long datatype from one table into another which contains a clob datatype? I'm told plsql can help achieve this.
Regards,
Leigh.

Report message to a moderator

Re: LONG to CLOB datatype conversion? [message #370015 is a reply to message #369998] Wed, 29 November 2000 20:32 Go to previous message
Tatsuhiko Maekawa
Messages: 3
Registered: November 2000
Junior Member
On PL/SQL
clob_field := to_lob(long_field)

Or, my feeling is that ordinary SQL should do it just fine.

I referred this idea from Oracle 8i SQL Reference. (And hope it works for you) Any other damn good idea?

Report message to a moderator

Previous Topic: Temp tbl query in stored proc creating performance issues-any thoughts?
Next Topic: insert/update LONG data >2000 characters
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 03 06:35:56 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.