Results 1 to 8 of 8

Thread: SQL validation help please

  1. #1
    Join Date
    May 2016
    Posts
    5

    Question SQL validation help please

    Good afternoon,

    Can someone please review this SQL statement and help me understand why the SQL trainer program is telling me I have a syntax error? I cannot find it and have looked for about an hour... I am new to writing SQL code. I can read it, but am just learning to write...

    Thank you.

  2. #2
    Join Date
    May 2016
    Posts
    5
    Here is the code...
    insert into
    Employees_SF1306
    (Firstname, Lastname,
    Title, Age, Salary)
    values ('Jonie', 'Weber',
    'Secretary', 28,
    19500.00);

  3. #3
    Join Date
    Sep 2002
    Posts
    5,938
    Which rdbms is it for? Do you have completed error message?

  4. #4
    Join Date
    May 2016
    Posts
    5
    It is in a testing environment, so there is no error message other than that there is a syntax error.

  5. #5
    Join Date
    Sep 2002
    Posts
    5,938
    For which rdbms?

  6. #6
    Join Date
    May 2016
    Posts
    5
    Quote Originally Posted by rmiao View Post
    For which rdbms?
    I am sorry, but I do not know what that means

  7. #7
    Join Date
    Feb 2014
    Location
    Riviera Beach, Maryland, USA
    Posts
    86
    Which relational database management system? (Oracle Database, Microsoft SQL Server, MySQL [Oracle], IBM DB2, IBM Informix, SAP Sybase Adaptive Server Enterprise, SAP Sybase IQ, Teradata, ...)
    Last edited by SpywareDr; 06-01-2016 at 08:09 AM.

  8. #8
    Join Date
    May 2016
    Posts
    5
    Quote Originally Posted by SpywareDr View Post
    Which relational database management system? (Oracle Database, Microsoft SQL Server, MySQL [Oracle], IBM DB2, IBM Informix, SAP Sybase Adaptive Server Enterprise, SAP Sybase IQ, Teradata, ...)
    Oracle I believe. It is a training program SQL Course, This was the help forum I found within that program

Posting Permissions

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