title: How to pass list of IDs from one Oracle schema to another?
body: <p>I use the Oracle SQL developer to query the Oracle database</p>
  
  <p>So, my simplified script is as follows:</p>
  
  <pre><code>alter session set current_schema=schema1;
  select id from table1
  
  alter session set current_schema=schema2;
  select * from table2 where remote_id in (&lt;the list from the 1st query in schema1&gt;)
  </code></pre>
  
  <p>Currently I copy the list from one schema to another manually.  How to automate passing the list?</p>