SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 Development Tools
 Other Development Tools
 Requesting Help with isql*plus script
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Camaro Z28
Starting Member

3 Posts

Posted - 12/09/2011 :  08:54:53  Show Profile  Reply with Quote

I am trying to write a script to create a table to include primary and foreign key constraints using Oracle isql*plus vs. 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

Flowing Fount of Yak Knowledge

8780 Posts

Posted - 12/09/2011 :  08:58:05  Show Profile  Visit webfred's Homepage  Reply with Quote
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

Starting Member

3 Posts

Posted - 01/04/2012 :  12:53:47  Show Profile  Reply with Quote
Hi your "Taxes number" shouldn't have a space either _ or no space that could be the problem

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000