DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2000
    insert into tnsnames (protocol, community)
    values ('tcp', 'tcp.world')
    where sid = 'DM5A'

    I keep getting sql command not properly ended??

    what am i doing wrong

  2. #2
    Join Date
    Oct 2000
    It looks from your post as if the record already exists - if so, you want to do an update, not an insert.

  3. #3
    Join Date
    Sep 2000

    WHERE clause should be NOT be used with INSERT statements. I think, there is already an existing record in the table and hence, you might want to update the existing one. Guess, this is what your ultimate goal is.

Posting Permissions

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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.