Coming soon - Get a detailed view of why an account is flagged as spam!
view details
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