Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Camaro Z28
Starting Member
3 Posts |
 Posted - 2011-12-09 : 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 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-12-09 : 08:58:05
|
These are MS SQL Server forums hence you can get better help in an oracle forum like http://www.dbforums.com/oracle/
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
HelpingOthers
Starting Member
3 Posts |
Posted - 2012-01-04 : 12:53:47
|
| Hi your "Taxes number" shouldn't have a space either _ or no space that could be the problemJ.Roberts |
|
|
|
|
|
|
Requesting Help with isql*plus script