The Joiner operator uses a boolean condition that relates column values in each source row set to at least one other row set. The Joiner operator results in a WHERE clause in the generated SQL query. When run on Oracle 9i, full outer joins are supported. For more information about joins, see Oracle Database SQL Reference.
Information captured from each device using inventory, asset and other IT solutions, is then stored in a common database from which reports are generated based on SQL queries and reporting features.
For each row generated by the SQL query, the SQL identifier (column name) maps to an XML element in the generated XML document, as shown in the following example
Output pane displays below the Design pane. Once you select objects and columns, you can create conditions, view the generated SQL, or view query results.
The SQL view presents a read-only, formatted representation of the SQL generated by Query Builder. You can copy the SQL code that appears in the SQL View for use in other tools such as SQL Command Processor or Application Builder.
Examples are used only to help you translate the word or expression searched in various contexts. They are not selected or validated by us and can contain inappropriate terms or ideas. Please report examples to be edited or not to be displayed. Potentially sensitive, inappropriate or colloquial translations are usually marked in red or in orange.