RE: PL/SQL Ordered Insert

Lyall & Rod,

Thanks for the suggestion. I'll pass this info along to my friend. Here's the reason the original question was posted: "Because there is a position passed in to tell the proc which record it needs. So if the order changes they can not predict what data they will retrieve. This ensures the data in rownum 4 will always be the same."

Thanks,
Stewart

> -----Original Message-----
> From: Lyall Barbour [SMTP:lbarbour_at_stanford.edu]
> Sent: Wednesday, August 16, 2000 7:35 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: PL/SQL Ordered Insert
>
>
> Man, Rod, you're too quick for me. Indexed-organized table is what I was
> going to say. But, I-O tables take a performance hit when inserting,
> deleting and updating. Of course, they're fantastic for queries, but
> because not to do too much i,u,d. They are usually simply look-up, static
>
> tables.
>
> Good luck Stu
> (I too would wonder about the purpose of this whole question in the first
> place.)
>
> Lyall Barbour
>
> At 02:19 PM 8/16/00 -0800, you wrote:
> >I might be wrong, but you can't have an order by in an
> >"insert into select ..from" statement
> >although you can do it using an ordered cursor and single row inserts.
> >
> >But having done all that the table would not be ordered as there is no
> >guarantee of data retrieval without an order by or a group by.
> >
> >The exception to this is an index_organised table but be aware of
> >limitations in
> >using this table, in that additional indexes may not be created. [I think
>
> >that
> >is still the case in 8.1.6 but haven't checked]
> >
> >I am more interested in why the table needs to be ordered in the first
> place.
> >
> >Surely if the indexation is fit-for-purpose then the notional ordering
> >of the rows is still impacted by the physical distribution of the data.
> >
> >Like Stephen, I may be missing something.
> >
> >cheers
> >
> >Rod
> >
> >--
> >Rod Corderey
> >
> >Lane Associates
> >RodCorderey_at_Lane-Associates.com
> >http://www.Lane-Associates.com
> >
> >"Manning, Stephen (calanais)" wrote:
> > >
> > >
> > > Wouldn't he just need to ORDER BY the source data? Or am I missing
> > > something.
> > >
> > > Stephen
> > >
> > > -----Original Message-----
> > > Sent: 16 August 2000 19:21
> > > To: Multiple recipients of list ORACLE-L
> > >
> > > A fellow DBA has a need to insert records into
> > > a temp table (in order) via a stored proc. Does
> > > anyone know a way to accomplish this?
> > >
> > > Apparently, SQL-Server has this ability and they're
> > > in the process of converting from SQL-Server to Oracle.
> > >
> > > TIA
> > > -----
> > > Stewart McGlaughlin
> > > Oracle DBA
> > > On-site at AT&T Wireless Services
> > > Oracle Links @ http://www.stewartmc.com/oracle
> > > stewartm_at_iname.com
> > >
> > > --
> > > Author: McGlaughlin,Stewart
> > > INET: mcglaughlin_at_attws.com
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing Lists
> > > --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> > > --
> > > Author: Manning, Stephen (calanais)
> > > INET: Stephen.Manning_at_calanais.com
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing Lists
> > > --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> >--
> >Author: Rod Corderey
> > INET: RodCorderey_at_Lane-Associates.com
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
>
> --
> Author: Lyall Barbour
> INET: lbarbour_at_stanford.edu
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Thu Aug 17 2000 - 08:36:54 CDT