Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Location
    USA
    Posts
    33

    Unanswered: Insert Statement

    hi all,

    how can i insert a value like this into a varchar field

    Insert into order (OrderText) values ('Toper://ui:0'Rex'sak_0');

    Now when i run it says
    ERROR at line 1:
    ORA-00917: missing comma

    Thanx.

  2. #2
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi,

    Code:
    Insert into order (OrderText) values ('Toper://ui:0''Rex''sak_0');
    Note that '' is two of ', and not a single ".

    P.S. A table called ORDER - most odd, would really, really want to change that if possible.

    Cheers
    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

Posting Permissions

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