title: How to optional update data on oracle?
body: <p>i have this table:</p>
  <pre><code>CREATE TABLE &quot;ALMAT&quot;.&quot;PRODUCT&quot; 
     (    &quot;ID&quot; NUMBER(*,0) NOT NULL ENABLE, 
      &quot;NAME&quot; VARCHAR2(50 BYTE), 
      &quot;PRICE&quot; NUMBER(*,0), 
      &quot;DESCRIPTION&quot; VARCHAR2(180 BYTE), 
      &quot;CREATE_DATE&quot; DATE, 
      &quot;UPDATE_DATE&quot; DATE, 
  CONSTRAINT &quot;PRODUCT_PK&quot; PRIMARY KEY (&quot;ID&quot;))
  </code></pre>
  <p>i want to update data in this table, this is my stored procedure:</p>
  <pre><code>CREATE OR REPLACE PROCEDURE UPDATEPRODUCT(prod_id int, prod_name varchar2 default null, prod_price int default null) AS 
  BEGIN
      
      
      update product
          set
          name = prod_name,
          price = prod_price,
          update_date = sysdate
          where id = prod_id;
          commit;
      
      
  END UPDATEPRODUCT;
  </code></pre>
  <p>im using optional parameters, how can i update only 1 column? for example: only &quot;NAME&quot; or &quot;PRICE&quot;.</p>