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.

 All Forums
 Development Tools
 Other Development Tools
 Requesting Help with isql*plus script

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.
Go to Top of Page

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 problem

J.Roberts
Go to Top of Page
   

- Advertisement -