top of page

SQL Developer [general]

Открытая·2 пользователя

Query editor: workspace menu



[EN]

The workspace menu expands the functionality of the editor by adding functionality and allowing optimal use of the editor's functionality

  • Copy - copy the selected text to the clipboard

  • Past - paste the contents of the clipboard into the editor window

  • Cut - cut selected text


18 просмотров
Гость
03 дек. 2024 г.

死ね

Query editor: code completion

[EN]

The code hint helps speed up writing a query by suggesting the names of schemas, tables, views, functions, procedures, packages, columns.

The code hint is activated when you press the dot "." button. or the key combination Ctrl + Space



For aliases of tables and views, a list of columns is displayed


25 просмотров

Query editor: workspace

[EN]

The work area is the field on the sheet for entering queries/commands.


Dividing code into component parts

The query editor engine parses the code before executing commands, identifying its components.

To separate the code, special characters are used (; - semicolon, / - slash, go - keyword on a separate line).


The program supports two code syntaxes


12 просмотров

Query editor: Control buttons



[EN]

Control buttons allow you to perform basic functions of the editor sheet.


  • Execute current SQL - run the currently selected query or all queries in the worksheet

  1. Execute - similar to pressing a button

  2. To run the script from a file - execute the script from disk. The script is not loaded into the editor.


12 просмотров

Участники

bottom of page