I'm sure that is why they don't mention it, but if you are using COTS software, there's a fair chance it will still use LONGs. Jared
On 5/24/05, Marquez, Chris <cmarquez@(protected)> wrote: > > Jared, > > Right, I saw you earlier post/example. > I guess Oracle is consider that LONG / LONG RAW is no longer supported? > > Chris Marquez > Oracle DBA > > > -- --Original Message-- -- > From: Jared Still [mailto:jkstill@(protected)] > Sent: Tue 5/24/2005 2:24 PM > To: Marquez, Chris > Cc: oracle-l@(protected) > Subject: Re: insert into select & datatypes? > > Unless of course that datatype happens to be a LONG or LONG RAW. > > -- > Jared Still > Certifiable Oracle DBA and Part Time Perl Evangelist > > > On 5/24/05, Marquez, Chris <cmarquez@(protected)> wrote: > > > > For those e keeping score at home. > > I asked Oracle Support about this subject; > > "Oracle Support For ''INSERT INTO...SELECT'' & DATATYPES Over DB Link" > > > > ======= > > ANSWER > > ======= > > There are no such datatypes which should not be used for "insert into > > select" > > So, In the statement > > Insert into t1 select * from t2 ; > > > > >
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist
