title: Creating temporary tables in oracle stored procedure
body: <p>I'm in the situation to create the procedure with 2 temporary tables.
  Example :
  ActionCode  1. If values are other than ADD/CHG/DEL, reject the record
  LastModifiedDate    "1. Mandatory field checking: if Null, reject the record
  2. Format validation: If other than yyyy-mm-dd hh:mm:ss format, reject the record
  3. If date greater than current date, reject the record"</p>
  
  <p>First temporay table will contain the records which satisfy first condidtion.
  2nd temporary table will contain the records which satisfy 2nd condition from the first temporary table record.
  Like that i have short down the records.
  Example out of 20 records 10 records satisfy the first condition , 1st temporary table will hold that.
  Then Out of that 10 records only 5 records satisfy 2nd condition, 2nd temporary table will hold that.
  Like that i have 20 condition to narrow down the records. PLease help me how i can achieve this. Thank you!</p>