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: RE: Urgent Select statement SOS

RE: RE: Urgent Select statement SOS

From: Yadav, Shailesh <NDASY3_at_labor.state.ny.us>
Date: Thu, 19 Jul 2001 07:32:38 -0700
Message-ID: <F001.0034E7A9.20010719064601@fatcity.com>

Dick,

  I guess i didn't understand the question right. I think you are right and before digging into the logminer it has to be seen how long a period of inserts are we talking about.

Shailesh

-----Original Message-----
Sent: Thursday, July 19, 2001 9:18 AM
To: Yadav; Shailesh; Multiple recipients of list ORACLE-L

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
--------------------------------------------------------------------
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
--------------------------------------------------------------------
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 Thu Jul 19 2001 - 09:32:38 CDT

Original text of this message

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