Re: Questions

In article <28cd2tINNdsd@emory.mathcs.emory.edu>, fms2000!johns@uunet.UU.NET (John Shoemaker) writes: |> Greatings, |> |> 1) |> Does anyone know which databases (if any) support a data type |> like the Informix SERIAL data type? My primary focus is on |> these databases: Oracle, Ingres, Sybase, RDB, etc. |> Sybase will support a SERIAL data type in Release 10. Ingres does not support it. Oracle7 supports serial data types using a sequence number generator. It is not as easy to use as the Informix SERIAL data type, and requires some additional programming. You have to create a sequence object on the database, and then reference the object every time you want the next value in the sequence. However, Oracle7 allows you to adjust the initial value and increment value. You can also use cycles, and specify maximum and minimum values. -------------------------------------------------------------------------- Curt Leaist |Internet: curtl@zed.com Project Zed |UUCP : ...!uunet!uupsi2!aruba!curtl --------------------------------------------------------------------------