Home > Data Nodes > Data Source Node > Explore Data Node > Graph Node > SQL Query Node > SQL Query Node Editor
The SQL Query node Editor allows you to define and validate a SQL query.
The editor provides specifications that can be dragged and dropped or double clicked into the query build text area.
The tabs on the left of the windows provide help in writing a query:
Source is a list of input nodes including both data provider nodes and model provider nodes. When you select an item in the Source list, information appears in the Message box.
Snippets are standard SQL Developer Snippets (SQL code fragment) arranged by by the type of calculation.
The snippet category Predictive Query helps write queries using the DBMS_PREDICTIVE_ANALYTICS PL/SQL package.
For information about snippets, see "Using Snippets to Insert Code Fragments" in SQL Developer Concepts and Usage. in Help > Table of Contents.
For a brief description of a snippets functionality, float the cursor over the name to display a tool tip.
PL/SQL Functions is a list of PL/SQL functions by user schema
R Scripts is a list of registered R Scripts; this tab is displayed if Oracle R Enterprise is installed
Write SQL in the text area.
Below the text area are:
Columns, list the columns and data types
Preview, displays a small number of the rows returned by the query
When you click OK or Validate, the following are checked:
The query generates at least one column of output.
All data types are data types that Data Miner supports. Most scalar data types are supported The most common data types that are not supported are user custom object types.
If unsupported data types are found, a table of columns generated is displayed and an error message is displayed above the column panel. All unacceptable data types in the column list are marked with an invalid icon next to the column name.
If no validation errors occur during the parsing of the query, the Columns tab shows data types of the columns and the Data tab shows a small sample of results.
If a validation error occurs, the validation panel is displayed in place of the Column and Data tab panel.