<div>
I think that you can use<br />
insert /*+ append */<br />
into &lt;&lt;your master table&gt;&gt;<br />
select
</div>


I think that you can use
insert /*+ append */
into <<your master table>>
select

<div>
Hi henka<br />
<br />
this is the first time I am writing SQL...could you kindly put together a simple sample SQL Statement. please.<br />
<br />
and much appreciated for the feedback.
</div>


Hi henka

this is the first time I am writing SQL...could you kindly put together a simple sample SQL Statement. please.

and much appreciated for the feedback.

<div>
Vitor Montalvão<br />
<br />
many thanks for the excellent feedback let me test...
</div>


Vitor Montalvão

many thanks for the excellent feedback let me test...

<div>
<div class="content wysiwyg-content">
Hi Experts <br />
<br />
I am after some SQL code for Oracle Discoverer.....which does the following sequence of steps:<br />
<br />
1. Run a SQL Code to pull data back from tables A, b and c (staff details)<br />
2. then append this data to a master table.<br />
2. then repeat step 1, with a slight change in SQL criteria and append the results back to step 2 the master table..<br />
<br />
so each time I change the selection criteria I want the end result to end up in the master table.
</div>
</div>


Hi Experts 

I am after some SQL code for Oracle Discoverer.....which does the following sequence of steps:

1. Run a SQL Code to pull data back from tables A, b and c (staff details)
2. then append this data to a master table.
2. then repeat step 1, with a slight change in SQL criteria and append the results back to step 2 the master table..

so each time I change the selection criteria I want the end result to end up in the master table.

SQL to append data to one fixed table...

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.