11-11-10, 01:54 #1Registered User
- Join Date
- Nov 2010
Unanswered: copy a long raw/ long data from one column to another Blob column in the same table
Can anyone suggest how to copy a long raw/ long data from one column to another Blob column in the same table .
I have tried
UPDATE TEST1 SET LONGRAW_TEMP = TO_LOB(LONGRAW);
but this dosent work .. gives an error (guess TO_LOB cannot be used with update query)
INSERT INTO TEST1 (LONGRAW_TEMP) (SELECT (TO_LOB(LONGRAW))FROM TEST1);
but it enters duplicate rows .
Any help is appreciated .
11-11-10, 12:33 #2Registered User
Provided Answers: 1
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
Ask Tom "how to select and insert a long type col..."
"A Long / long raw that is greater then 32k cannot be inserted into another table via
plsql. You must use C or VB or Java or someother language for that. The SQLPLUS copy
command works as well."You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.