Creating Multiple table in Oracle

Question

I am using Oracle Express 10g and I'm enter the following text to create 2 tables in the sql command line, but it is not working.

CREATE TABLE student (
    matric_no     VARCHAR2(8),
    first_name    VARCHAR2(20),
    last_name     VARCHAR2(20),
    date_of_birth DATE
);

CREATE TABLE student1 (
    matric_no     VARCHAR2(8),
    first_name    VARCHAR2(20),
    last_name     VARCHAR2(20),
    date_of_birth DATE
);

Can anyone see what I am doing wrong.

Thanks

"It's not working" is not a valid Oracle error message. Please post the full error message that you get. — user330315
– user330315, Commented Nov 3, 2011 at 21:57
The statements are fine (I copied them and ran them locally just to be sure). Did you copy & paste the SQL from somewhere? Maybe there are some invisible characters that make SQL*PLus choke. — user330315
– user330315, Commented Nov 3, 2011 at 22:11

Community · Accepted Answer · 2017-05-23 12:11:31Z

1

By "command line" you probably mean the web application that comes with Oracle Express 10g. This application has several browser incompatibilities and is basically unable to execute several statements at once (also see Oracle 10g - invalid character on DB importing).

Either put your statements in a text file and upload them as a SQL script. Or switch to a better tool such as SQL Developer (downloadble from Oracle web site).

edited May 23, 2017 at 12:11

CommunityBot

11 silver badge

answered Nov 4, 2011 at 8:35

Codo

79.7k18 gold badges177 silver badges219 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Raoul George · Accepted Answer · 2011-11-04 11:42:19Z

0

Are you sure you didn't type this out in WORD?

Sometimes there are problems with "invisible" characters. For example if you hit TAB in WORD, it will store it as a special character which will thereby cause an error when you try running it in SQLPlus.

answered Nov 4, 2011 at 11:42

Raoul George

2,7971 gold badge24 silver badges25 bronze badges

Collectives™ on Stack Overflow

Creating Multiple table in Oracle

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related