title: Oracle SQL Delete Record without affecting child tables
body: <p>I've got many tables in my database, but my problem is concerned to this two tables:</p>
  
  <p><a href="https://i.stack.imgur.com/2o0Bs.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2o0Bs.png" alt="ERD"></a>
      .</p>
  
  <p>The definiton of those is:</p>
  
  <pre><code>Employee (EmployeeID_PK, FirstName, LastName, Email, ...)
  Order    (OrderID_PK, EmployeeID_FK, OrderDate, MenuID, ...)
  
  *_PK = Primary Key
  *_FK = Foreign Key
  </code></pre>
  
  <p>Now I want to <strong>delete</strong> a Employee so that he's not able to login anymore, but I still need to have his orders and his attributes (like FirstName, LastName, ...).</p>
  
  <p>So the data should stay in the tables, but the employee shouldn't be able to login anymore.</p>
  
  <p>I know that adding a column 'isactive' to Employee would be a solution, but I don't think that it's the best way to do this. Please tell me anyway, if it's the only way to do it.</p>
  
  <p>Thanks in advance!</p>