Re: insert into select & datatypes?

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: "Marquez, Chris" <cmarquez@xxxxxxxxxxxxxxxx>
  • Date: Tue, 24 May 2005 22:16:14 +0100

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@xxxxxxxxxxxxxxxx> 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@xxxxxxxxx]
> Sent: Tue 5/24/2005 2:24 PM
> To: Marquez, Chris
> Cc: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxxxxx> 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

--
//www.freelists.org/webpage/oracle-l

Other related posts: