I have a USER table in Oracle with the following columns
The database can have these records and I am given a set of IDS and names to update the DEPT field to a new number. Is there a single command I can user to insert/or update the record given an ID? In other words:
if the record exist,
then update DEPT and set DATE_MODIFIED
INSERT with all values.
Is there a simple way to do it other than doing a select for it and then deciding to insert or not?