1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Asking for help. New to Database and Oracle. Struggling Student

Discussion in 'SQL PL/SQL' started by AlaskaSH, Dec 15, 2011.

  1. AlaskaSH

    AlaskaSH Active Member

    Messages:
    2
    Likes Received:
    2
    Trophy Points:
    65
    Hello,

    I am trying to work on creating our tables for our database. I was able to add my first two tables but now I am getting "invalid identifier" when trying to add the next two tables.

    CREATE TABLE course
    (
    course_id NUMBER NOT NULL,
    course_name VARCHAR2(50) NOT NULL,
    course_location VARCHAR2(50) NOT NULL,
    course_section VARCHAR2(50) NOT NULL,

    CONSTRAINT dept_pk
    PRIMARY KEY (course_id),

    );


    CREATE TABLE syllabus
    (
    syllabus_id NUMBER NOT NULL,
    syllabus_image BLOB,

    CONSTRAINT syllabus_pk
    PRIMARY KEY (syllabus_id),


    );

    I was hoping someone could point me in the right direction.
     
  2. AlaskaSH

    AlaskaSH Active Member

    Messages:
    2
    Likes Received:
    2
    Trophy Points:
    65
    Okay,

    Nevermind, I just saw my mistake. I am new to all this. I removed my miss placed comma on my constraint.

    I will power on.

    Thank you and I like the site.
     
    Bharat and Sadik like this.