Re: Insert A Record

From: Jason Lester <jasonl_at_sysao.com>
Date: Mon, 26 Jul 1999 15:25:41 GMT
Message-ID: <379c7d8b.23463438_at_nnrp.news.uk.psi.net>


On Mon, 26 Jul 1999 13:00:35 GMT, "Peter Barker" <p-barker_at_its-ltd.co.uk> wrote:

>Using a data block that has multiple lines, how can the user insert a new
>record before record one?
>

Since Oracle is a relational database, you can't insert records in specific places, since the position of the data is not relevant (unless I've missed the point of the question). If you want to order the data, you need a seperate column to hold the record number (or something similar).

Jase Received on Mon Jul 26 1999 - 17:25:41 CEST

Original text of this message