Query editor workspace
The workspace is that field on the sheet for entering queries/commands.
Splitting code into component parts
The query editor engine, before executing commands, parses the code, determining the constituent parts.
Special characters are used to separate code (; - semicolon, / - slash, go - keyword on a separate line).
The program supports two code syntaxes
Classic syntax Oracle : The ; character is used to separate commands from each other. (semicolon) excluding commands create, begin, declare - these commands are separated from others by the character / (slash) on a separate line
Syntax MSSQL Server : Use the go keyword on a separate line to separate commands from each other
It is allowed to use either of the two syntaxes, including both at the same time
Logging of performed operations
The text of any SQL command/query is stored in local storage after execution ( Core base - C$QUERY_HISTORY table ). The database records: the text of the request/command of the program actually executed by the core, execution status, execution time, number of lines changed, database messages (output)
In addition to saving the data in the database, the progress of each command is recorded on the " Messages " tab of the sheet:
command execution status
line numbers in the editor on which the executed command is located
Tab data is cleared before running commands