Re: How to insert records by descending order of date ...

I've done this in the past by creating an index on the column you want to order by and then loading the target table in this way (e.g.):
  INSERT INTO taba (col_list)
  sELECT (col_list)
  FROM source_table
  WHERE date_col < '31-DEC-2099';

The '<' condition (should) cause the index to be "walked" in a descending order, giving you a de facto order by clause.

• Steve Alred

Disclaimer: Personal post! Opinions, etc., are

            strictly my own. Received on Tue Sep 05 1995 - 00:00:00 CEST