|
Camaro Z28
Starting Member
USA
3 Posts |
 Posted - 12/09/2011 : 08:54:53
|
Hello,
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
(
Customer_ID Varchar2(20),
Date_Rented Date,
Date_Returned Date,
Unique_Video_ID_Number Int not null,
Unique_DVD_ID_Number Int not null,
Late_Damaged_Fees Int,
Failure_Rewind_Fees Int,
Taxes Number,
Primary Key (Customer_ID)
) ;
Can someone please help me because I am a beginner to writing sql plus.
Thank you!
edit: moved to proper forum |
|
Requesting Help with isql*plus script
