Re: Problems with SEQUENCES!

From: Robert Ottohall <rob_at_ohall.com>
Date: Mon, 5 Oct 1998 22:26:12 +0200
Message-ID: <6vba4a$juf$1@goof.de.uu.net>

Is it this you want:

create sequence canon;
update scott.emp set sal=canon.nextval

Lars Jütten wrote in message <3618F211.15328CAB_at_ibh.rwth-aachen.de>...
>Hi everybody!
>
>I have a problem with SEQUENCES in databases. Although i think they are
>very usefull i don't know anything about their usage.
>How can i insert values into a table and use the defined sequence to
>generate a unique key value. Defining the sequence is no problem.
>I'm working with WinNT 4.0 and Oracle 7.3.3 on an UNIX workstation.
>For conversation i use ODBC driver Ora ... v2.5
>
>Thank you very much,
>
> Lars Jütten
Received on Mon Oct 05 1998 - 15:26:12 CDT