Posted - 12/09/2011 : 08:54:53
I am trying to write a script to create a table to include primary and foreign key constraints using Oracle isql*plus vs. 10.2.0.4.0. when I use the app. text editor and execute the below script, I get an error message indicating that either missing a keyword or parenthesis.
create table Customer_Rental
Unique_Video_ID_Number Int not null,
Unique_DVD_ID_Number Int not null,
Primary Key (Customer_ID)
Can someone please help me because I am a beginner to writing sql plus.
edit: moved to proper forum