SQL creating table error

Question

We are using Oracle 11g to create our tables and database. If I create a table EX

CREATE TABLE  "ALIASES" 
   (    "ALIAS_ID" NUMBER(6), 
    "CRIMINAL_ID" NUMBER(6,0), 
    "ALIAS" VARCHAR2(20)
   ) ;

Then it creates the table fine, but when I try to create multiple tables at a time EX

CREATE TABLE  "ALIASES" 
   (    "ALIAS_ID" NUMBER(6), 
    "CRIMINAL_ID" NUMBER(6,0), 
    "ALIAS" VARCHAR2(20)
   ) ;



   CREATE TABLE  "CRIMINALS" 
   (    "CRIMINAL_ID" NUMBER(6,0), 
    "LAST" NUMBER(15,0), 
    "FIRST" NUMBER(10,0), 
    "STREET" VARCHAR2(10), 
    "CITY" VARCHAR2(20), 
    "STATE" CHAR(2), 
    "ZIP" CHAR(5), 
    "PHONE" CHAR(10), 
    "V_STATUS" CHAR(1), 
    "P_STATUS" CHAR(1)
   ) ;

then I get a ORA-00911: invalid character error. How can I get an error from 2 tables that both work if I did them seperately, but dont work if I do them together.

Where do you run these statements? Which SQL tool do you use? Maybe your SQL tool doesn't support running multiple statements? — user330315
– user330315, Commented Sep 16, 2015 at 6:09
We are using oracle 11g express edition. It is the only software the teacher said we would need.(SQL workshop) — Brandon Schiff
– Brandon Schiff, Commented Sep 16, 2015 at 6:11
Oracle 11g XE is not a "SQL client". It's the DBMS. You need to tell which tool you use to run the SQL statements (SQL*Plus, SQL Developer, some other tool...) — user330315
– user330315, Commented Sep 16, 2015 at 6:12
You can create two tables without a / .. I just checked on fiddle — Amnesh Goel
– Amnesh Goel, Commented Sep 16, 2015 at 6:27
We didnt actually have one I just downloaded SQL developer though — Brandon Schiff
– Brandon Schiff, Commented Sep 16, 2015 at 6:29

Mindaugas Tamosevicius · Accepted Answer · 2015-09-16 06:22:54Z

1

I copied Your code into file named test.sql then ran sqlplus, and got the answer:

SQL> @test

Table created.


Table created.

SQL>

Check the encoding of the file or the tool You use.

answered Sep 16, 2015 at 6:22

Mindaugas Tamosevicius

1726 bronze badges

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

3 Comments

Brandon Schiff Over a year ago

this is the whole table chart if there is anyway you can see why it wont work with the full thing pastebin.com/6guMREXa

Mindaugas Tamosevicius Over a year ago

Unfortunatelly I'm behind the corporate firewall. Try run the script with Oracle sql developer and post the error.

Brandon Schiff Over a year ago

I think I got it to work, so it was just my program couldnt process more then one table at a time, Thank you

Collectives™ on Stack Overflow

SQL creating table error

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related