How to copy data with "Long Raw" columns
From time to time I will be faced the problem to move data from one table to another. Under normal circumstances this is not a big deal, but if the source table contains a long-/raw column this is impossible to manage that with plain SQL. So here is a suitable workaround to solve this problem with a few lines of PL/SQL code
Starting point is a table with a long raw column:
1 | insert into long_table |
2 | select 'new id', |
3 | long_column /* LONG-Feld */ |
4 | from long_table a |
5 | where a.long_id = 'some old id'; |
This ends up with "ORA-00997: illegal use of LONG datatype error"
The workaround is:
01 | declare |
02 | l_rec_long_table long_table%rowtype; |
03 | begin |
04 | select * |
05 | into l_rec_long_table |
06 | from long_table a |
07 | where a.long_id = 'some old id'; |
08 | |
09 | insert into long_table |
10 | values |
11 | ('new id', |
12 | l_rec_long_table.long_column); |
13 | end; |
Visits
Today 43 | Week 514 | Month 1686 | All 1173875
Donalds Daily Dumbs (The Guardian)
Donald Trump | The Guardian
14 June 2025
News about Donald Trump, the 45th and 47th US president, including comment and features from the Guardian
-
Trump’s military parade taps an ancient tradition of power: from Mesopotamia to Maga
Critics see echoes of authoritarianism, a break from the US’s usual restraint on military
... -
From Gaza to Ukraine to Iran, Trump’s ‘peacemaker’ promise collapses
A president who vowed to end global conflicts has instead presided over their escalation – his
... -
Netanyahu outplayed Trump on Iran. Now the US risks being mired in another war | Mohamad Bazzi
If Trump wants to be the peacemaker he claims to be, he must negotiate a new deal with
...
Latest Articles
Most Popular Articles last 24h
- Hippe E-Bikes - 30 hits
- How to handle Oracle BLOB columns via Database Link - 15 hits
- Joomla 3: Change the Order of Featured Articles - 11 hits
- Trumps (ehemalige?) Vasallen - Heute: Elon Musk - 10 hits
- "Habeck ist schuld" - oder - Die mediale Vernichtung der Grünen - 9 hits
- Mont Ventoux ³ - 8 hits
Most Popular Articles last Week
- Gegen alle Widerstände zum Erfolg: Trondheim - Oslo 2017 - 614 hits
- Trumps (ehemalige?) Vasallen - Heute: Schon wieder Elon Musk (3) - 190 hits
- How to handle Oracle BLOB columns via Database Link - 186 hits
- How to create an APEX Plugin - 165 hits
- How to Java programming in Oracle Database - 159 hits
- Trumps Vasallen - Heute: FIFA und Herr Giovanni I. - 145 hits
Challenges Completed
StackOverflow
