SEQUENCE IN ORACLE

From: <deepakrajan_at_hotmail.com>
Date: Fri, 17 Apr 1998 04:15:40 -0600
Message-ID: <6h76js$us8$1@nnrp1.dejanews.com>

Hi,

I want to generate unique values using a single Sequence in Oracle 7 database for columns in two tables(Column x is the primary key column for Table A and Column y is the primary key column for Table B)I wish to know if I can assign values for column x and column y using a single Sequence.I wanna know if Oracle Will assign the correct sequence for each of the columns (x or y) when I use the sequence.next_val syntax while inserting new rows in either Table A or Table B.Anyone please answer me.

Thanks in advance for your help.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri Apr 17 1998 - 05:15:40 CDT