Re: Referencing an Oracle Sequence

From: Galen Boyer <galendboyer_at_yahoo.com>
Date: 13 Apr 2002 20:41:16 -0500
Message-ID: <ubscmubw3.fsf@rcn.com>

On 13 Apr 2002, dkniveton71_at_msn.com wrote:

> insert into orders values (customer_id.NextVal);

              ^^^^^^

I assume you meant customer?

[...]

> insert into orders values ('0000000001','<??WHAT GOES HERE??>');

                                            ^^^^^^^^^^^^^^^^^^^
                                            customer_id.currval

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.

Received on Sat Apr 13 2002 - 20:41:16 CDT