Description

The OracleSQLFileInsertReceiver creates a file with standard ANSI SQL insert statements for Oracle Database. 


Parameters

The following parameters can be defined for the OracleSQLFileInsertReceiver. Items with an asterisk (*) are required. 

  • path* - Defines the directory path where the file will be stored. 
  • subDir - Defines an optional sub-directory where the file will be stored. 
  • fileName* - Defines the name of the file the SQL statement will output to. 
  • tableName* - Defines the name of the SQL table as it is in the database. 
  • batchCount* - Defines the number of insert statements written to file in each batch.
  • appendToFile* - Determines whether the file will open in append mode. If true, SQL statements will be appended to the file; otherwise, the file will be overridden.
  • uniqueAttribute - Defines a Domain Attribute the Receiver will use to identify a unique value that has already been inserted to the file and prevents it from being inserted twice. 
  • statementSeparator* - Defines when a SQL statement has ended. 
  • rowDelimiter* - Defines the characters to delimit each row. 
  • booleanValue* - Format a Boolean object with the selected mask (true\false, on\off, yes\no, etc.).
  • nullValue* - Represents a null value. 
  • quoteTextData* -Defines the character to use when quoting text data.


Row Delimiter

There are two rowDelimiter types:

  • UNIX/Linux/Mac-LF - Used for Mac, Unix & Linus machines.
  • Windows-CR/LF - Used for Windows machines.

Receiver Attribute Property Keys

The Receiver defines three property keys that can be modified on any of its associated Domain Attributes:

  • columnName - Defines the actual column name used in the database table.
  • include - Defines if the Attribute will be included in each SQL statement.
  • useQuotes -Determines if a value should be quoted. Sometimes a numeric value should be quoted (e.g. SSN).


Column Name

Be sure to pay attention to the naming of the column names for each Attribute. They must match the column name as it is defined in the database table.



Example Output

The following is an example output of Oracle SQL insert statements into a user table.


insert into user(id,first_name,last_name,middle_initial,emailAddress) values ('1','Penelope','Spaeth','F','user@email.com');
insert into user(id,first_name,last_name,middle_initial,emailAddress) values ('2','Carla','Elledge','U','user@email.com');
insert into user(id,first_name,last_name,middle_initial,emailAddress) values ('3','Tori','Adamson','R','user@email.com');
SQL