Re: numbering function

From: Thomas Bierhance <Bierhance_at_orbital-computer.de>
Date: Thu, 05 Aug 1999 01:04:27 +0200
Message-ID: <37A8C6FB.C9CC7215@orbital-computer.de>

> Personal Oracle 7.3

I'm not sure about this one, may be it's different from "my oracles"...

> I've a 100,000 record table. I've a field named Num and I want to
> automatically fill it starting from 1 to the number of records. The table
> must be ordered for a certain criteria before numbering. How can I do? I
> have to use a single command to put in my Delphi program.

you could write a stored procedure (I don't know if you could use the rownum in an update statement...). Would that be a solution? Received on Wed Aug 04 1999 - 18:04:27 CDT