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" <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
