Re: Automatic random number on row creation

Kuon wrote:

> I know something like that:
> select dbms_random.string('U', 20) str from dual
>
> for my random number.
>
> But how, when I do:
>
> insert into myTable (otherInfos) values ("myotherinfos"),
>
> how can the "key" column been automaticaly assigned a random and unique
> string?

insert into myTable (key,otherInfos) values (dbms_random.string('U',20),"myotherinfos");

Or am I missing something?

Kind regards,

-- 
Seven-hundred tons of metal a day
Now sir you tell me the world's changed
Once I made you rich enough
Rich enough to forget my name