title: Writing a stored proc in oracle
body: <p>I am new to oracle and I am facing this problem of creating a stored procedure. If anyone can help , I will be really grateful.</p>
  
  <pre><code>Create procedure in `ABC` schema with input params as: `NUM1`, `STATUS1`
  
  Check if `NUM` exists in `ABC.STATUS` table
  
  If exists
  
  Update the `STATUS` with input parameter passed and `LAST_UPDATED` with `SYSDATE` of `ABC.STATUS`
  
  Else
  
  Insert record with `NUM` and `STATUS` with input parameters and `LAST_UPDATED` with `SYSDATE` of `ABC.STATUS`
  </code></pre>