Re: automatic / auto-increment field, without trigger

From: BicycleRepairman <engel.kevin_at_gmail.com>
Date: Thu, 9 Dec 2010 05:23:53 -0800 (PST)
Message-ID: <94f11c42-49a3-4fbc-adc8-86f0d6e8e82a_at_s4g2000yql.googlegroups.com>

On Dec 9, 2:59 am, fel0niousmonk <fel0ni..._at_gmail.com> wrote:
> if i don't have access to create a trigger, but can add/drop/alter
> tables.
>
> is there a way to define an automatic column (by sequence) in the
> create table sql without using a trigger?

alter table foo add (myGUIDColumn raw(16) default sys_guid());

It's not a sequence, but it is guaranteed unique. Received on Thu Dec 09 2010 - 07:23:53 CST