| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Automatic random number on row creation
"Cris Carampa" <cris119_at_operamail.com> wrote in message
news:43b40de0$0$329$5fc30a8_at_news.tiscali.it...
> Cris Carampa wrote:
>
>> insert into myTable (key,otherInfos) values
>> (dbms_random.string('U',20),"myotherinfos");
>>
>> Or am I missing something?
>
> Yes, I missed the word "unique" in the original post. Mladen's response is
> perfect, then.
>
> --
>
looks like concatenating a sequence or just trapping UK violation would finish the story
++ mcs Received on Thu Dec 29 2005 - 12:05:41 CST
 |
 |