title: PL-SQL delete value from variable
body: <p>In a PL SQL procedure I've a variable(declare as NUMBER) as follows,</p>
  
  <pre><code>Store_Values
  </code></pre>
  
  <p>I'm loading some data into this variable by select query.So if this data matches to the value(some value which will be compared against variable in if statement),then how to delete matched value from variable.
  below is the procedure:</p>
  
  <pre><code>CREATE OR REPLACE PROCEDURE UPDATE_SIG_NAME_MAPS(SignatureID NUMBER, RuleCateory VARCHAR2, SignatureMessage VARCHAR2, IsDelete NUMBER, IsNew NUMBER) AS
  NumberOfValues      NUMBER ;
  BEGIN
  select VALUE BULK COLLECT into NumberOfValues from list_details where LIST_CONFIG_ID in(fetching from other table's);
  if NumberOfValues = SignatureID then
  **delete from sometable with where clause**
  end if;
  insert variable remaining values to the table using for loop
  END ;
  /
  </code></pre>