Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Long data type
Why does Long data type has the following restriction?
Can not be referenced in Insert...Select...
So you need to first Insert without the Long column, and then do an Update. I did not see an obvious reason for this forced inefficiency.
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Feb 17 1999 - 12:18:49 CST