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?

On Dec 9, 2:59*am, fel0niousmonk <fel0ni... (AT) gmail (DOT) com> wrote:
alter table foo add (myGUIDColumn raw(16) default sys_guid());

It's not a sequence, but it is guaranteed unique.

On Wed, 08 Dec 2010 23:59:49 -0800, fel0niousmonk wrote:

Most databases use triggers under the hood for implementing the auto-
increment type. However, with oracle, there is another option: you can
create your own type and declare the column to be of that type. That will
prove to be a very interesting solution, especially if you try loading
something using SQL*Loader or replicating the table to another schema or,
god forbid, another database, using Golden Gate, for instance. I can even
think of interesting moments with export import. You will learn what is
the "transform" option in the impdp actually made for.



--
http://mgogala.byethost5.com