Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Automatic random number on row creation

Re: Automatic random number on row creation

From: Cris Carampa <cris119_at_operamail.com>
Date: Thu, 29 Dec 2005 17:24:21 +0100
Message-ID: <43b40de0$0$329$5fc30a8@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.

-- 
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
Received on Thu Dec 29 2005 - 10:24:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US