I'm trying to
UPDATE values in an Oracle database table (of salary information) that has no row IDs or a primary key. I'm writing these statements in LinqPad.
This syntax should work just fine in SQL Server SQL:
UPDATE schedule_amounts SET ANNUAL_RATE = 44000 WHERE SCHEDULE_ID = 'LCSD' and SCHEDULE_NO = 2014 and SCHEDULE_LEVEL = 100 and SCHEDULE_STEP = 17 SELECT * FROM schedule_amounts
But the driver LinqPad uses is returning
ORA-00933: SQL command not properly ended.
WHERE conditions is the only way I can specify the exact row I need to update. I have Googled Oracle's
UPDATE syntax but I just can't seem to find an easy-to-understand example of how to do what, to me, is rather simple in SQL Server.