Re: Auto-generated columns on Oracle

Postgresql also recently improved their support in this area (in version
10). It's more like syntactic sugar on top of things you could already do,
but I'd be interested to know if it can be used by Cayenne in the same way
as the MySQL auto-increment columns.

The DDL syntax is supposedly an SQL standard:

CREATE TABLE test_new (
    id int GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
    payload text
);


On Mon, May 27, 2019 at 1:49 AM Andrus Adamchik <[email protected]>
wrote:

> Looks like Oracle started supporting auto-increment columns since 12c:
>
>
> https://www.arungudelli.com/tutorial/oracle/auto-increment-identity-column-in-oracle-table-primary-key/
>
> We should try using that in the adapter.
>
> Andrus