The INSERT statement

The INSERT statement tells the archecker utility what tables to extract and where to place the extracted data.

Syntax


1  INSERT INTO target_table? (+ , target_column)  SELECT
2.1 + , src_column
2.1 *  FROM src_table?  WHERE filter
Element Description
filter The following filters are supported by the INSERT statement:
  • =, !=, <>
  • >, >=, <, <=
  • [NOT] MATCHES, [NOT] LIKE
  • IS [NOT] NULL
  • AND, OR
  • TODAY, CURRENT
The following operators are not supported by the archecker utility:
  • Aggregates
  • Functions and procedures
  • Subscripts
  • Subqueries
  • Views
  • Joins

Filters can only be applied to physical-only restore.

src_column A list of columns to be extracted.
src_table The source table on the archive where the data is restored from.
target_column The destination column or columns where the data will be restored.
target_table The destination table where the data will be restored.

Examples

The following example demonstrates the simplest form of the INSERT statement. This statement extracts all rows and columns from the source to the target table.
INSERT INTO target SELECT * FROM source;
You can also extract a subset of columns. In the following example, only two columns from the source table are inserted into the destination table.
CREATE TABLE source (col1 integer, col2 integer, col3 integer, col4 integer);
CREATE TABLE target (col1 integer, col2 integer);
INSERT INTO target (col1, col2) SELECT col3, col4 FROM source;