Re: Sequences
From: Jack Richter <jarichter2_at_freezone.co.uk>
Date: Fri, 17 Sep 1999 01:30:34 +0100
Message-ID: <37e18b19.0_at_news1>
Date: Fri, 17 Sep 1999 01:30:34 +0100
Message-ID: <37e18b19.0_at_news1>
Ken,
You don't "assign sequences to a column. You select values from sequences
and use them in your update/insert of data into columns in the table....i.e.
INSERT INTO my_table (cust_id, last_name) VALUES (seq_cust_id.next_val,
'SMITH');
Regards
Jack Richter
Ken Halsted wrote in message ...
>I just created a sequence. How do I assign the sequence to a column on the
>table I want to use?
>
>Ken.
>
>--
>_________________
>Kenneth W. Halsted
>Mountaire Corporation
>ph: (501) 399-8812
>url: http://www.mountaire.com
>email: kenman_at_mail.snider.net
>
>
>
Received on Fri Sep 17 1999 - 02:30:34 CEST