Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: insert into select & datatypes?

Re: insert into select & datatypes?

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 24 May 2005 22:16:14 +0100
Message-ID: <bf463805052414163b477242@mail.gmail.com>


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_at_collegeboard.org> 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_at_gmail.com]
> Sent: Tue 5/24/2005 2:24 PM
> To: Marquez, Chris
> Cc: oracle-l_at_freelists.org
> 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_at_collegeboard.org> 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

--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 24 2005 - 17:21:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US