Re:RE: Urgent Select statement SOS

From: <dgoulet_at_vicr.com>
Date: Thu, 19 Jul 2001 07:00:47 -0700
Message-ID: <F001.0034E75E.20010719062142@fatcity.com>

That is dependent on their being a date of last posting or similar column in the table. If not then it depends. Assuming the table is inserted into ONLY and there have been NO deletes, then a simple 'select * from <table_name>' will extract the data in the order that it was most likely inserted, though that is NOT guaranteed. If on the other hand there have been any deletes against the table, your totally stuck. There is no data that I know of in the data dictionary that records when a row was inserted into a table. Possibly, but again no guarantee, logminer may be of assistance, if you've got the right version of Oracle.

Dick Goulet

____________________Reply Separator____________________
Author: "Yadav; Shailesh" <NDASY3_at_labor.state.ny.us>
Date:       7/19/2001 5:56 AM

Sinardy,

Try something like this...

INSERT INTO table_name (SELECT column_name FROM (SELECT column_name FROM table_name ORDER BY time))

HTH
Shailesh

-----Original Message-----
Sent: Thursday, July 19, 2001 8:55 AM
To: Multiple recipients of list ORACLE-L

Hi all,

Do you guys know how to
select column
order by time of insert into table.

Thank you,

Sinardy

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Sinardy
INET: sinardyxing_at_bcsis.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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Yadav, Shailesh
INET: NDASY3_at_labor.state.ny.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------