Maybe that's a question for the sandbox, but let's see..
(Background: My tables have usually max. up to 1000-2000 rows; my knowledge is not thaat big and maybe I'm looking at the wrong direction; a lot of values has to be updated based on other tables like CSV..)
Example (I hope not to weird..):
I have external data, based on many, small CSV, like this (50 - 1000 lines)
In Oracle, I have the similar table with parts of the data
Now I have to "update" Oracle - "update table set fullname = 'Jim' where id = 1" - to be continued with every line ... Then I have to update "value = test + length" ..
Now I create a SQL-statement with an editor - it works, but I'm sure that's not the best way.
What better ways would you recommend?
Thanks a have a good time!