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!

ORA-00904: : Invalid Identifier

Discussion in 'SQL PL/SQL' started by pvvenkat1, Jul 26, 2012.

  1. pvvenkat1

    pvvenkat1 Guest

    CREATE TABLE MyVillage
    (
    Pid NUMBER(6),
    Fname VARCHAR2(30),
    Mname VARCHAR2(20),
    Lname VARCHAR2(30),
    Gender CHAR(1),
    DOB DATE,
    Equa VARCHAR2(15),
    Occu VARCHAR2(20),
    Aincome NUMBER(9),
    House VARCHAR2(10),
    Hnumber NUMBER(5),
    Land NUMBER(5,1),
    );
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi venkat,

    Code (Text):

    CREATE TABLE MyVillage
    (
    Pid NUMBER(6),
    Fname VARCHAR2(30),
    Mname VARCHAR2(20),
    Lname VARCHAR2(30),
    Gender CHAR(1),
    DOB DATE,
    Equa VARCHAR2(15),
    Occu VARCHAR2(20),
    Aincome NUMBER(9),
    House VARCHAR2(10),
    Hnumber NUMBER(5),
    Land NUMBER(5,1)
    );
     
    You have provided comma(,) at the end of final column. Thats the reason the table is not getting created.
     
  3. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO