Re: Automatic random number on row creation


"Cris Carampa" <cris119@xxxxxxxxxxxxx> wrote in message
news:43b40de0$0$329$5fc30a8@xxxxxxxxxxxxxxxxxx
> 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


.

Relevant Pages

  • Re: Compact connected Hausdorff
    ... > of U are also open in X (a relatively open subset of an open set is ... > What am I missing? ... Prev by Date: ...
    (sci.math)
  • Form.SetBounds
    ... missing something here? ... Letting is become visible and then setting ... Steve ... Prev by Date: ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Exclusive checkboxes
    ... only one option button on the whole page/sheet can be selected. ... I dont know if there is a way of grouping the options together. ... let me know if I am missing something. ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: stop script if dates are missing, edit help...
    ... he wanted the ability to enter the start date in 1/1/2005 format and ... right on column J, which is K, if any of those are missing to print out ... msg box and basically stop and say: make sure the dates in the range ... Prev by Date: ...
    (microsoft.public.excel)
  • Missing start menu - What componet?
    ... get is log off and the shutdown options. ... What am I missing? ... Jason ... Prev by Date: ...
    (microsoft.public.windowsxp.embedded)