Insert into table on the Linked Server with data from local table
<p>I'm working with SQL Server Express, I created a linked server to an Oracle database. </p>

<p>As the title indicates, I want to insert data selected from a local table into a table at the Linked Server.</p>

<p>I tried many queries but no one of them worked as I want.</p>

<p>This query below I used has worked, but only with static values, but I want to insert data dynamically from the a table on local database.</p>

<pre><code>INSERT OPENQUERY (ORTEST, 'SELECT * FROM reservation')
VALUES (2, '2', 3);
</code></pre>