title: How to query from multiple tables of date range in oracle
body: <p>I have oracle tables like below <code>schema.ITEM_DATA_2017_01_01, schema.ITEM_2017_01_02, schema.ITEM_DATA_201_01_03</code> .... like that with same column names. Actually these are the history table which will create when running a job.
  How do i perform a search across all the tables given a date range using sql developer.
  Please help.</p>
  
  <p>Regards, 
  Ramesh</p>