Editor SQL
The form "SQL Editor" allows Invantive UniversalSQL access to the contents of a databases.
First choose the database to use. The database chosen will be displayed in the menu group until disconnected:
The SQL editor will open and display three groups:
Pulsanti
The "Execute" button runs the Invantive UniversalSQL statement in which the cursor is positioned within. A selection runs as one statement, also when it holds an empty line. The key combination is Ctrl+Enter.
From release 28.0, and in its beta release 27.1, the "Execute All" button runs every statement of the selection, or of the whole text when nothing is selected, one after the other. Statements are separated by an empty line, as in Query Tool. The run stops at the first statement which fails. The key combination is Ctrl+Shift+Enter.
The "Disconnect" button disconnects from the database and also removes the database from the menu group.
The "SQL Grammar" button displays the Grammar for reference purposes.
Elementi
The SQL editor window is displayed on top. It grows to accommodate more text when necessary.
The "Available Objects" tab displays the objects per data container. Double click on an object to insert a statement to retrieve the data into the SQL editor.
The "Results" tab displays the results of the query:
The "Search" box allows entry of a text used to restrain the results to solely rows containing the search text in any column.
After "Execute All", the results show the last statement which returned rows. A list above the results chooses the result of another statement.
The "Output" tab shows the lines written with dbms_output. From release 28.0, and in its beta release 27.1, the lines appear while the statement runs, and a statement which fails keeps its lines.
Running Statements
From release 28.0, and in its beta release 27.1, a mark in the margin left of the line numbers shows where each statement stands while it runs:
- an arrow while the statement runs;
- a tick when it succeeded;
- a cross when it failed;
- a square when it was stopped.
The lines of the running statement and of a failed statement are tinted. A screen reader announces the same changes in words.
The "Cancel" button stops the statements being executed. Leaving the page stops them as well. A statement which runs longer than the execution limit of Invantive Cloud is stopped; the time counts the execution only.
Progresso
The "Progress" tab draws what the statement being executed is doing while it runs: every step of the execution as a card, the rows passing from one step to the next as lines, and on each card the rows, the time, the calls and the bytes of that step. The panel draws in the light or dark appearance of the page. The question mark at the right of its tool strip opens the help of the panel, which explains every mark on a card with a numbered sheet per kind of card. "Pace", "Freeze All" and "Release 10 Rows" on the tool strip hold back the whole statement. They change when the rows are handed on, not what the statement returns. From release 28.0, and in its beta release 27.1, a pace or "Freeze All" chosen before "Execute" applies to the statement from its start. Under "Freeze All" every step waits before it asks a data container anything, so the picture shows what the statement is going to do; "Unleash All" lets it go on. With "Execute All", each next statement follows what the tool strip says when it starts. Clicking a card opens a drawer below the picture with the figures of that step and three buttons:
- "Peek at the Rows" keeps a copy of the rows the step hands on and shows them under the names the columns carry in the statement. At most a hundred rows are kept, and at most a megabyte.
- "Freeze This Step" holds the step while the rest of the statement runs. The button stays pressed while the step is held; pressing it again lets the step go on. From release 28.0, and in its beta release 27.1, "Unleash All" on the tool strip releases it as well; before, only pressing the button again did.
- "Release 10 Rows" lets a held step hand on ten rows and freeze again. Up to and including release 27.0 this button reads "Hand On Ten Rows", and the one on the tool strip reads "Step 10".
Identical Steps
Many steps which do the same thing, such as the read in every iteration of a loop, are drawn as one card which carries their number. Its drawer lists the steps one row each, with the rows, the duration, the calls and the failure of each. From release 28.0, and in its beta release 27.1, the buttons in the drawer of such a card act on all of those steps together, also on the steps which start later in the same run, such as the read of the next iteration of the loop. "Freeze This Step" reads "Freeze These Steps" there. "Release 10 Rows" lets ten rows through among all of those steps, and "Peek at the Rows" keeps the rows of all of them. Before, these buttons acted on the first of the steps only, which in a loop has usually ended.


