2
SQL CREATE TABLE trouble...
Post Body
Hello! This is my first time working with SQL and I am using oracle's SQLplus.
I am just trying to create a table and insert a handful of rows into this table. In my .txt file I have this...
CREATE TABLE freshmen(
FR_NO char(3),
FR_FIRSTNAME varchar2(30),
FR_LASTNAME varchar2(30),
FR_DATEJOINED date,
ACT number(2),
CITY varchar2(30),
PRIMARY KEY(FR_NO)
);
When I run this file oracle tells me I have an error at the line
CREATE TABLE freshmen(
and the error is ORA-00933: SQL command not properly ended. I have spent about an hour trying to figure out how I am writing this syntax wrong and I can't figure it out. Any help would be much appreciated! Thanks.
Author
Account Strength
100%
Account Age
12 years
Verified Email
Yes
Verified Flair
No
Total Karma
8,878
Link Karma
399
Comment Karma
8,080
Profile updated: 1 week ago
Posts updated: 10 months ago
Subreddit
Post Details
We try to extract some basic information from the post title. This is not
always successful or accurate, please use your best judgement and compare
these values to the post title and body for confirmation.
- Posted
- 9 years ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/learnprogra...