Hi,
I'm new to SQL. I need to create a table that
has a primary key to be used by a CMP entity
bean. I used following to create the table:
create table my_table(id not null number,
val_1 number, val_2
string)
ID is the primary key. Does above SQL statement requires id
to be unique? If not, what should I do to modify
the SQL statement? What should I do to add a
foregin key in above statement?
Thanks so much.