Page 1 of 2 12 LastLast
Results 1 to 15 of 20
  1. #1
    Join Date
    Jan 2009
    Posts
    12

    Unanswered: could any body help me

    i made this programe when i compile it ii get this massage(Illegal GET command)(object FlightDetails does not exis) so could any body plz fig out what the wrong in my pograme ????

    CREATE TABLE FlightDetails(

    FirstName Varchar2(20) NOT NULL,
    LastName Varchar2(20) NOT NULL,
    Date Number(20) NOT NULL,
    Gate Number(20),
    Seat varchar2(20),
    From-to varchar2(20),
    FlightNumber varchar2(20),
    class Varchar2(20),
    DepartureTime Number(20),
    ArriveTime Number(20),
    PRIMARY KEY (FirstName,LastName,Date));

    CREATE TABLE CustomerDescription(

    FirstName varchar2(20) NOT NULL,
    LastName varchar2(20) NOT NULL,
    Email varchar2(20) NOT NULL,
    Age Number(5),
    PhoneNumber Number(20),
    AdditionalMeal varchar2(20),
    City varchar2(20),
    Address varchar2(50),
    PRIMARY KEY (FirstName,LastName,Email));

    CREATE TABLE Payment(

    FirstName varchar2(20) NOT NULL,
    LastName varchar2(20) NOT NULL,
    Time Number(20) NOT NULL,
    Email varchar2(20) NOT NULL,
    PaymentId Number(20),
    PaymentAmount Number(20),
    ExpiredDate Number(20),
    PRIMARY KEY(FirstName,LastName,Time,Email));

    CREATE TABLE Booking (

    FirstName varchar2(20) NOT NULL,
    LastName varchar2(20) NOT NULL,
    Date DATE NOT NULL,
    Time Number(20) NOT NULL,
    Code varchar2(50),
    Status Number(20),
    PRIMARY KEY(FirstName,LastName,Date,time));

    CREATE TABLE Ticket (

    FirstName varchar2(20) NOT NULL,
    LastName varchar2(20) NOT NULL,
    Date DATE NOT NULL,
    TicketCode varchar2(20),
    TicketDescription varchar2(20),
    PRIMARY KEY (FirstName,LastName,Date));



    INSERT INTO FlightDetails VALUES ('Isa','Ahmed','01-01-2009',3,'2A','Bahrain-to-London','2A03','First Class','14:30','23:30');
    INSERT INTO FlightDetails VALUES ('Nor','Ali','07-07-2009',10,'13C','New york-to-Birmingham','3A33','Business Class','11:00','14:45');
    INSERT INTO FlightDetails VALUES ('Salman','Isa','20-12-2009',21,'20E','UAE-to-Paris','1A27','Economy Class','00:00','17:25');
    INSERT INTO FlightDetails VALUES ('Nasser','Hassan','03-03-2009',13,'7D','Oman-to-Doha','2B13','Business Class','10:00','12:00');


    INSERT INTO CustomerDescription VALUES ('Isa','Ahmed','Isa@hotmail.com',20,+97336469391,' Yes','HamadTOwn','Home 1266');
    INSERT INTO CustomerDescription VALUES ('Nor','Ali','Nor@gmail.com',30,+97339220164,'No', 'IsaTOwn','Home 9231');
    INSERT INTO CustomerDescription VALUES ('Salman','Isa','Smd@yahoo.com',45,+9731776268,'Ye s','Manama','Home 3214');
    INSERT INTO CustomerDescription VALUES ('Nasser','Hassan','Na32@hotmail.com',34,+97339856 412,'Yes','Sitrah','Home 4321');


    INSERT INTO Payment VALUES('Isa','Ahmed','13:00','Isa@hotmail.com',001 3,'$620','31-12-2008');
    INSERT INTO Payment VALUES('Nor','Ali','17:00','Nor@gmail.com',0241,'$ 200','06-07-2009');
    INSERT INTO Payment VALUES('Salman','Isa','23:45','Smd@yahoo.com',0233 ,'$634','19-12-2009');
    INSERT INTO Payment VALUES('Nasser','Hassan','19:50','Na32@hotmail.com ',0121,'$150','02-03-2009');



    INSERT INTO Booking VALUES ('Isa','Ahmed','01-01-2009','13:00','J73215A','Confirm');
    INSERT INTO Booking VALUES ('Nor','Ali','07-07-2009','17:00','AB74321','Confirm');
    INSERT INTO Booking VALUES ('Salman','Isa','20-12-2009','23:45','ZW8453J','NotConfirm');
    INSERT INTO Booking VALUES ('Nasser','Hassan','03-03-2009','19:50','4213608','NotConfirm');


    INSERT INTO Ticket VALUES ('Isa','Ahmed','01-01-2009','76A21','Confirm');
    INSERT INTO Ticket VALUES ('Nor','Ali','07-07-2009','23B21','Confirm');
    INSERT INTO Ticket VALUES ('Salman','Isa','20-12-2009','AZ217','NotConfirm');
    INSERT INTO Ticket VALUES ('Nasser','Hassan','03-03-2009','427B8','NotConfirm');

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >From-to varchar2(20),
    dash characters are not valid within field name(s); use from_to instead.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    Quote Originally Posted by taktak88
    i made this programe when i compile it ii get this massage(Illegal GET command)(object FlightDetails does not exis) so could any body plz fig out what the wrong in my pograme ????
    I have not idea "plz fig out" means, but then I'm not a native speaker.
    Can you please explain that to me?

    What is a "plz" and what do I do to "fig it out"?
    In Germany PLZ is the abbreviation for the Zipcode, but I can't really imagine how that would fit in here.

    The code you posted is not a "program" it's a sequence of SQL statements.
    SQL Statements are not "compiled", they are executed/run using some kind of client application.

    So, how do you run those statements (SQL*Plus, some other SQL client?)

    I don't think "Illegal GET command" is an standard Oracle error message.

    So please post the full error message you get including error codes.

  4. #4
    Join Date
    Jan 2009
    Posts
    12
    sorry about that could you plz show me an example how because at school they learn as like that and i have eight knowledge in sql

  5. #5
    Join Date
    Jan 2009
    Posts
    12
    plz that mean Please

    and fig that mean figure out

  6. #6
    Join Date
    Jan 2009
    Posts
    12
    Quote Originally Posted by shammat
    I have not idea "plz fig out" means, but then I'm not a native speaker.
    Can you please explain that to me?

    What is a "plz" and what do I do to "fig it out"?
    In Germany PLZ is the abbreviation for the Zipcode, but I can't really imagine how that would fit in here.

    The code you posted is not a "program" it's a sequence of SQL statements.
    SQL Statements are not "compiled", they are executed/run using some kind of client application.

    So, how do you run those statements (SQL*Plus, some other SQL client?)

    I don't think "Illegal GET command" is an standard Oracle error message.

    So please post the full error message you get including error codes.



    in our school they learn us to write the program in notepad than we save it for example abc.sql after that we open oracle pulse and we open the notepad file and then we write this statement like for example (desc FlightDetails or select * from FlightDetails) to show us the table

  7. #7
    Join Date
    Jan 2009
    Posts
    12
    now its work with me but there is problem when i write this statment to show me the table i get this problem
    ERROR at line 4:
    ORA-00904: : invalid identifier

  8. #8
    Join Date
    Jan 2009
    Posts
    12
    sorry about that i have question how to display the table like that for example
    NAME CAMPUS DEPT PHONE YEAR
    SMITH CENTRAL IRM 303 492-9473 1994
    SMITH CENTRAL IRM 303 492-9473 1993
    SMITH CENTRAL IRM 303 492-9473 1992
    SMITH CENTRAL UMS 303 492-9473 1991
    SMITH CENTRAL UMS 303 492-9473 1990

    Thank you for your helping

  9. #9
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    show up what you tried and we will help. We will not do your homework.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  10. #10
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Quote Originally Posted by taktak88
    when i write this statment to show me the table i get this problem
    ERROR at line 4:
    ORA-00904: : invalid identifier
    What statement? What table? Which line is line 4?

  11. #11
    Join Date
    Jan 2009
    Posts
    12
    Quote Originally Posted by beilstwh
    show up what you tried and we will help. We will not do your homework.

    i know that i will do it be myself be i need some of help when i compile it like i wrote select*from FlightDetails; to show me the table i get this error and i would like to know what should i write in me program to keep like for example all first name of flightdetails in one line and last name in one line

  12. #12
    Join Date
    Jan 2009
    Posts
    12
    the problem in date so what should i do i keep it as a number is it correct ???
    or what should i defined it??

  13. #13
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >the problem in date so what should i do i keep it as a number is it correct ???
    No
    >or what should i defined it??
    DATE datatype
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  14. #14
    Join Date
    Jan 2009
    Posts
    12
    thank you and what about Time????

  15. #15
    Join Date
    Jan 2009
    Posts
    12
    for time is it TIMESTAMP the type of the time i must defined it??

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •