7.18 Language Editor

Use to define the languages used by Oracle Data Integrator.

Oracle Data Integrator uses computer languages to access technologies. These languages are used to generate the procedures executed on these technologies. The correct definition of the characteristics of a language is therefore essential for the correct generation and execution of the procedures.

In Oracle Data Integrator, a language is described by its language elements assembled in sub-languages.

The languages are used for:

Determining the language elements available in the Expression Editor.
Managing the separators and delimiters of language words when generating procedures.

Concepts

A language is made up of three types of words:

Objects: Named entities handled by the language (tables, schemas, columns).
Literals: Values that the language handles (for example, content of a record column in a table, for SQL language).
Reserved words: Specific to the language, and are usually the names of functions, commands, and so forth.

The Language Editor has the following tabs:

7.18.1 Definition

Properties	Description
Name	Name of the language.

Delimiters

This section allows the characters used as delimiters to be defined for the language.

Properties Description

Objects

Properties	Description
Objects	Pairs of characters that allow the names of objects to be delimited. This type of character is generally used to protect the case (upper/lower) or to protect the possible separators of special words or characters used in object names. Each pair is made up of a start character and an end character, and there cannot be more than two characters. Examples: Square brackets (`[]`) For example: `[Active Customers]` The square bracket is necessary to protect the space and the case in the name of the object Active Customers. Double quotes (`""`) For example: `"Account"."Licenses"` The quotation marks are used to protect the accents and the case in the name of the objects Account (schema) and Licenses (datastore).
Literals	Pairs of characters allowing literals (values) to be delimited. Each pair is made up of a start character and an end character, and there cannot be more than two characters. For example: '' : 'Welcome to Paris !'. The quotation marks are used to protect the accents, the case, and the special characters in this literal.

Pairs of characters that allow the names of objects to be delimited. This type of character is generally used to protect the case (upper/lower) or to protect the possible separators of special words or characters used in object names.

Each pair is made up of a start character and an end character, and there cannot be more than two characters.

Examples:

Square brackets ([])

For example: [Active Customers]

The square bracket is necessary to protect the space and the case in the name of the object Active Customers.
Double quotes ("")

For example: "Account"."Licenses"

The quotation marks are used to protect the accents and the case in the name of the objects Account (schema) and Licenses (datastore).

Literals

Pairs of characters allowing literals (values) to be delimited.

Each pair is made up of a start character and an end character, and there cannot be more than two characters.

For example:

'' : 'Welcome to Paris !'. The quotation marks are used to protect the accents, the case, and the special characters in this literal.

Case-Sensitive

Determines the case-sensitivity for the language.

Properties	Description
Objects	Indicates whether the language differentiates upper and lower case for the names of the objects it processes, such as the names of columns, tables, and schemas.
Reserved keywords	Indicates whether the language differentiates upper and lower case for its reserved words, such as SELECT or INSERT.

Word Separators

The characters used to separate the words of the language.

Oracle Fusion Middleware Developing Integration Projects with Oracle Data Integrator