Chapter 7 - Query 111 About Query 111 RDBMS 112 Query Editor 112 Query Builder (Available only in Non-Essentials Edition) 116 Query Parameters 122 Debug Oracle Query (Available only Query Results 122 MongoDB 123 Query Editor 123 Find Builder (Available only in Non-Essentials Edition) 126 Aggregate Builder (Available only in Non-Essentials Edition) 127 Query Results Results 128 Redis 128 Query Editor 128 Query Results 132 Code Snippets (Available only in Non-Essentials Edition) 133 Chapter 8 - Model (Available only in Navicat Premium and Enterprise Edition)

Chapter 7 - Query 109 About Query 109 RDBMS 110 Query Editor 110 Query Builder (Available only in Non-Essentials Edition) 114 Query Parameters 120 Debug Oracle Query (Available only Query Results 120 MongoDB 121 Query Editor 121 Find Builder (Available only in Non-Essentials Edition) 125 Aggregate Builder (Available only in Non-Essentials Edition) 126 Query Results Results 126 Redis 127 Query Editor 127 Query Results 130 Code Snippets (Available only in Non-Essentials Edition) 131 Chapter 8 - Model (Available only in Navicat Premium and Enterprise Edition)

Chapter 7 - Query 108 About Query 108 RDBMS 109 Query Editor 109 Query Builder (Available only in Non-Essentials Edition) 113 Query Parameters 119 Debug Oracle Query (Available only Query Results 119 MongoDB 120 Query Editor 120 Find Builder (Available only in Non-Essentials Edition) 124 Aggregate Builder (Available only in Non-Essentials Edition) 125 Query Results Results 125 Redis 126 Query Editor 126 Query Results 129 Code Snippets (Available only in Non-Essentials Edition) 129 Chapter 8 - Model (Available only in Navicat Premium and Enterprise Edition)

Server configuration Connection Management Users Authentication methods User credentials storage Query Manager Supported databases Features Database navigator DB Navigator folders Simple and Advanced Panel JSON and Document View Data export Entity Diagrams SQL Editor Query Execution Plan Visual Query Builder Log Viewer Query History Resource Manager Installation Running from Docker Build and results panel is opened Write SQL query and press or click the icon Ctrl-Enter Execute Query results will be shown in a tab on the SQL results panel Execute SQL query CloudBeaver User Guide 22.3. Page

Connection Management Access Management Users Teams Authentication methods User credentials storage Query Manager Supported databases Authentication Theming Localization Features Database navigator Document View Data export Entity Diagrams Document viewer SQL Editor Query Execution Plan Visual Query Builder Log Viewer Query History Resource Manager Running from Docker Build and deploy Demo results panel is opened 4. Write SQL query and press Ctrl-Enter or click the Execute icon 5. Query results will be shown in a tab on the SQL results panel Execute SQL query CloudBeaver user guide 23.0 7/111

configuration Connection Management Users Teams Authentication methods User credentials storage Query Manager Drivers Management Supported databases Features Database navigator DB Navigator toolbar Panel JSON and Document View Data export Entity Diagrams SQL Editor Query Execution Plan Visual Query Builder Log Viewer Query History User Guide Table of contents User Guide CloudBeaver User Guide results panel is opened Write SQL query and press or click the icon Ctrl-Enter Execute Query results will be shown in a tab on the SQL results panel Execute SQL query CloudBeaver User Guide 23.1. Page

Templates Management Users Teams Users Provisioning Authentication methods User credentials storage Query Manager Drivers Management Supported databases Features Create Connection Database navigator Panel JSON and Document View Data export Entity Diagrams SQL Editor Query Execution Plan Visual Query Builder Log Viewer Query History Resource Manager Installation Installation Version upgrade results panel is opened Write SQL query and press or click the icon Ctrl-Enter Execute Query results will be shown in a tab on the SQL results panel Execute SQL query CloudBeaver User Guide 23.2. Page

Templates Management Users Teams Users Provisioning Authentication methods User credentials storage Query Manager Drivers Management Supported databases Features Create Connection Database navigator and Document View Data export Entity Diagrams SQL Editor Query Execution Plan Visual Query Builder AI Smart Assistance Log Viewer Query History Resource Manager Installation Installation Version Version upgrade Workspace backup Configuration Server configuration Query manager database configuration CloudBeaver User Guide 23.3. Page 4 of 252. Configuring server datasources Connection configuration

Installation Application Window Overview Views Database Navigator Projects View Project Explorer Query Manager Background Tasks Database Object Editor Properties Editor Data Editor Navigation Data SQL Editor SQL Templates SQL Assist and Auto-Complete SQL Formatting SQL Execution Visual Query Builder User Guide Table of contents General User Guide DBeaver User Guide 21.2. Page 3 of 263. Script you can select the type of SQL query to generate: - SELECT - INSERT - UPDATE - DELETE - MERGE - DDL Clicking one of the items (for example INSERT) generates a relevant query in a separate window. Export

Installation Application Window Overview Views Database Navigator Projects View Project Explorer Query Manager Background Tasks Database Object Editor Properties Editor Data Editor Navigation Data SQL Editor SQL Templates SQL Assist and Auto-Complete SQL Formatting SQL Execution Visual Query Builder User Guide Table of contents General User Guide DBeaver User Guide 6.2. Page 3 of 263. Script you can select the type of SQL query to generate: - SELECT - INSERT - UPDATE - DELETE - MERGE - DDL Clicking one of the items (for example INSERT) generates a relevant query in a separate window. Export