title: Oracle query/ stored procedure to return multiple resultsets
body: <p>I am using oracle database. When I tried to fetch the data using a single select query, it returned a single table in the dataset. 
  How to write a select query or procedure in oracle, where I can get a dataset with 2-3(multiple) tables?</p>