declare @newKey integer
select @newKey = coalesce(max(actionkey),0)+1 from tbale_name
update tableName set NewActionKey=@newKey, @newKey=@newKey+1
update tablename set ActionKey = @newKey+2
go
Can anyone help me translate this SQL server syntax into something that Oracle will understand. I am a complete newbie to Oracle and need to get this to work.
Please!!! and Many thanks!!!!
select @newKey = coalesce(max(actionkey),0)+1 from tbale_name
update tableName set NewActionKey=@newKey, @newKey=@newKey+1
update tablename set ActionKey = @newKey+2
go
Can anyone help me translate this SQL server syntax into something that Oracle will understand. I am a complete newbie to Oracle and need to get this to work.
Please!!! and Many thanks!!!!