RE: PL/SQL Ordered Insert

From: Manning, Stephen (calanais) <Stephen.Manning_at_calanais.com>
Date: Wed, 16 Aug 2000 19:24:22 +0100
Message-Id: <10591.114754@fatcity.com>

Wouldn't he just need to ORDER BY the source data? Or am I missing something.

Stephen

-----Original Message-----

From: McGlaughlin,Stewart [mailto:mcglaughlin_at_attws.com] Sent: 16 August 2000 19:21
To: Multiple recipients of list ORACLE-L Subject: PL/SQL Ordered Insert

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).

Received on Wed Aug 16 2000 - 13:24:22 CDT