dbForge Studio for Oracle
  • Documentation center

  • Table of Contents

  • Get started
    • Copyright Information
    • Requirements and Compatibility
    • Installation
      • How to install dbForge Studio
      • Installation from the Command Line
    • How to run dbForge Studio on Linux & macOS
      • Using CrossOver
        • Installation Overview
        • Manual Installation of dbForge Studio via CrossOver
        • Command-Line Mode on Linux
        • Command-Line Mode on macOS
      • Using Wine
        • Install the Studio on Ubuntu
    • Third-party software
    • Uninstalling dbForge Studio for Oracle
    • Data storage and transmission policy
    • Connecting to a Database
    • Creating and Editing a Query
    • Creating a Query in Query Builder
    • Editing Data
    • Creating a Table in Table Editor
    • Backing up a Database
    • Licensing and activation
      • Licensing
      • Activating dbForge Studio for Oracle
  • Connecting to Databases
    • Managing Database Connections
    • Viewing Database Schema Information
    • Oracle Administrative Privileges for connection to the server
    • How dbForge Studio for Oracle is involved in the DevOps process
  • Writing and Executing SQL Statements
    • Writing SQL Statements
    • Executing SQL Statements
    • Writing SQL Queries with Code Completion
    • Working with Code Snippets
    • Working with Literals
    • Viewing Server Messages and Errors
    • Using Parameters
    • SQL Query History
    • Executing Large Scripts
    • Opening Large Scripts in SQL Editor
    • Associating Windows with Connection
    • SQL Document Shortcut Keys
    • Executing Scripts through the Command Line
    • Formatting Code through the Command Line
    • SQL*Plus Command Support
    • Phrase Completion
    • Renaming Objects
    • Renaming Variables
    • Managing Aliases
    • PL/SQL Context Prompt
  • Building Queries with Query Builder
    • Query Builder Overview
    • Adding Tables to Query
    • Removing Tables from Query
    • Including Columns in Query
    • Making Joins Between Tables
    • Building WHERE or HAVING Clause
    • Including Fields in GROUP BY or ORDER BY Clauses
    • Building a Query in Visual Mode
    • Subqueries Overview
    • Subqueries in From Clause
    • Subqueries in Other Clauses
    • Navigating Query with Document Outline
  • Working with Query Diagram
    • Diagram Overview
    • Diagram Layout
    • Aligning Shapes
    • Changing Shape Size
    • Controlling Spacing between Shapes
    • Diagram Shortcuts Overview
    • Focus and Selection Shortcuts
    • Zoom and Scroll Shortcuts
    • Shape and Column Managing Shortcuts
  • Working with Data in Data Editor
    • Viewing Data in Grid Overview
    • Sorting Data in Grid
    • Grouping Data in Grid
    • Filtering Data in Grid
    • Server-Side and Client-Side Sorting and Filtering
    • Paginal Mode
    • Auto-Search Mode
    • Card View
    • Editing Data in Grid Overview
    • Foreign Key Lookup
    • Data Shortcut Keys
  • Exporting and Importing Data
    • Data Export Overview
    • Exporting Data
    • Export Oracle data to CSV
    • Export Oracle data to Excel
    • Saving and Using Templates During Data Export
    • Exporting Data through Command Line
    • Data Import Overview
    • MS Access Import
    • Import a CSV file into the Oracle table
    • DBF Import
    • Import an Excel file into the Oracle table
    • Google Sheets Import
    • Text Import
    • XML Import
    • JSON Import
    • Migrating Data from Other Servers
    • Saving and Using Templates During Import
    • Importing Data to a New Table
    • Importing Data through Command Line
    • Additional /dataimport Arguments
    • Additional /dataexport Arguments
  • Data Analysis
    • What is Pivot Table?
    • Creating a Pivot Table
    • Creating a Chart in Pivot Table
    • Reordering Fields
    • Filtering Fields
    • Sorting Fields
    • Grouping Fields
    • Using Summary Functions to Calculate Custom Totals
    • Applying Conditional Styles
    • Printing
    • Areas
    • Headers
    • Filter Field
    • Column Field
    • Row Field
    • Data Field
    • Totals
    • Grand Totals
    • Viewing Data in Related Tables
    • Working with Self-Referencing Tables in Master-Detail Browser
    • Working with Master-Detail Browser Document
    • Sorting and Filtering Data in Master-Detail Browser
    • Tips for Working with Master-Detail Browser
  • Working with Schema Objects
    • Creating, Viewing, Dropping, and Editing Tables in Oracle Database
    • Defining Table Structure
    • Unique and Primary Keys
    • Check Constraints
    • Foreign Keys
    • Object Tables
    • Clustered Tables
    • Index-Organized Tables
    • Partitioning Basics
    • Creating Partitioned Tables with Range, Hash or List Partition Methods
    • Creating Partitioned Tables with Composite Partition Methods
    • Adding and Removing Partitions and Subpartition
    • Using Subpartition Template
    • Managing Views in Oracle
    • Procedures and Functions
    • Package Specification
    • Package Body
    • Packages and Programs Compilation
    • Object Type Specification
    • Object Type Body
    • Database Links
    • Materialized Views
    • Materialized View Logs
    • Collection Type
    • Clusters
    • Managing Sequences in Oracle
    • Synonyms
    • Triggers
    • Creating XML Schema
    • Dropping XML Schema
    • Creating and Dropping XML Tables
    • Creating a Copy of Schema Object
    • Displaying the Number of Database Objects
    • Generating DDL Statements for Schema Objects
    • Filtering Schema Objects
    • Deleting Schema Objects
    • Viewing Object Dependencies
    • Compiling Schema Objects
  • Searching for Objects and Data
    • Searching schema objects in Oracle databases
    • Searching Table and View Data
    • Managing Search Results
    • Finding and Recompiling Invalid Objects
  • Designing Databases
    • How to create an ER diagram in Oracle?
    • Adding Database Objects to a Diagram
    • Deleting or Editing Database Object on a Diagram
    • Creating a Many-to-Many Relationship Between Tables
    • Saving and Restoring a Diagram
    • Exporting a Diagram
    • Printing a Diagram
    • Searching Text on the Database Diagram
    • Setting Diagram Options
    • Additional Elements on a Diagram
    • Editing Tables
    • Displaying Database Objects on a Diagram
    • Working with Relations
    • Relation Notations
    • Diagram Shapes and Layout
  • Export and Import of Oracle Schemas
    • Copying Oracle Schema
    • Schema Export and Import
    • Exporting Schema through Command Line
    • Importing Schema through Command Line
    • Additional /schemaexport and /schemaimport Arguments
    • Using Command Line To Create Database Snapshots
  • Managing Users and Privileges
    • User Management Concepts
    • Setting Up a New User Account
    • Manipulating User Accounts
    • Working with Privileges
    • Manipulating Roles
    • Granting and Revoking Roles
    • Manipulating Profiles
    • Working with Multiple Users
    • Generating DDL
    • Duplicating Security Objects
    • Watermarks in Security Manager
    • How to check the account that the SQL Server Agent is using
  • Debugging PL/SQL Units
    • Debugger Overview
    • Debugging a Stored Procedure
    • Debugging a Stored Function
    • Debugging a Trigger
    • Debugging Object Method
    • Debugging a Package
    • Debugging a SQL Script
    • Execution Control
    • Working with Breakpoints
    • Debug Shortcut Keys
  • Optimizing SQL Queries
    • Getting Query Profiling Results
    • Comparing Query Profiling Results
  • Schema Comparison and Synchronization
    • Synchronizing Two Schemas
    • Saving and Loading Schema Comparison
    • Setting up Schema Comparison
    • Grouping and Filtering Comparison Results
    • Comparing Objects' DDL
    • Previewing Schema Synchronization Script
    • Generating Comparison Report
    • Synchronizing Schemas
    • Comparing and Synchronizing Schemas through Command Line
    • Comparing Database Snapshots through Command Line
    • Additional /schemacompare Arguments
    • Command Line Options for /schemacompare Operation
    • Schema Comparison and Synchronization Overview
    • Viewing Schema Differences Overview
    • Comparing and Synchronizing Schemas on Different Oracle Server Versions
    • Creating a New Snapshot in Schema Compare
    • Exit codes used in Command Line for /schemacompare
  • Data Comparison and Synchronization
    • Setting Up Data Comparison
    • Mapping Tables and Views
    • Mapping Columns
    • Setting Comparison Key
    • Filtering Rows Included into Comparison
    • Mapping Warnings
    • Data Comparison Options
    • Viewing Data Comparison Results
    • Generating Data Comparison Report
    • Synchronizing Data
    • Synchronization Warnings
    • Comparing and Synchronizing Data through the Command Line
    • Scheduling Database Synchronization
    • Additional /datacompare Arguments
    • Command Line Options for /datacompare Operation
    • Parameters Used in Command Line
    • Type Compatibility Table
    • Data Comparison Process Overview
    • Data Synchronization Process Overview
    • Exit codes used in Command Line for /datacompare
  • Working with Data Generator
    • Setting Up Data Generator
    • Using Generators
    • Generating Data for Empty Database
    • Populating Database
    • Creating Custom Generators
    • Generating Data through the Command Line
  • Documenting Oracle Schemas
    • Generating Database Document
    • Documenting Databases through the Command Line
  • Performing Administration Tasks
    • Using Oracle Export and Import Utility
    • Retrieving Information about Current Sessions
    • Using Cursor List
    • Terminating and Disconnecting Session
    • Enabling and Disabling SQL Trace
    • Controlling Sessions
    • Alerts and Pipe Messages
    • Receiving and Sending Alerts and Pipe Messages
  • Developing Database Projects
    • Creating and Opening Projects
    • Managing Files in Projects
    • Working with Database Objects in Project
    • Using Project Build Configurations
    • Building and Deploying Project
    • Working with Project
    • Database Project Overview
    • Project Connection
    • Manipulating Database Object Shortcuts
    • Project Build Overview
  • Writing Data Reports
    • Creating a Static Report
    • Creating a Simple Data-Aware Report
    • Creating a Master-Detail Report
    • Saving and Loading Reports
    • Exporting Data Reports to Various Formats
    • Creating a Report through Command Line
    • Additional /datareport Arguments
    • Data Reports Overview
    • Report Building Basics
    • Designer Elements
    • Measure Units
    • Report Bands
    • Report Controls
    • Smart Tags
    • Context Links
  • Automating Operations
    • Creating Command Line Execution File
  • User Interface Concepts
    • Manipulating Tabs and Documents
  • Release notes and other versions
    • dbForge Studio for Oracle release history
    • dbForge Studio for Oracle v6.0 release notes
    • dbForge Studio for Oracle v4.6 release notes
    • dbForge Studio for Oracle v4.5 release notes
    • dbForge Studio for Oracle v4.4 release notes
    • dbForge Studio for Oracle v4.3 release notes
    • dbForge Studio for Oracle v4.2 release notes
    • dbForge Studio for Oracle v4.1 release notes
    • dbForge Studio for Oracle v4.0 release notes
    • dbForge Studio for Oracle v3.10 release notes
    • dbForge Studio for Oracle v3.9 release notes
    • dbForge Studio for Oracle v3.8 release notes
    • dbForge Studio for Oracle v3.7 release notes
    • dbForge Studio for Oracle v3.6 release notes
    • dbForge Studio for Oracle v3.5 release notes
    • dbForge Studio for Oracle v3.1 release notes
    • dbForge Studio for Oracle v3.0 release notes
    • dbForge Studio for Oracle v2.55 release notes
    • dbForge Studio for Oracle v2.50 release notes
    • dbForge Studio for Oracle v2.0 release notes
    • dbForge Studio for Oracle v1.51 release notes
    • dbForge Studio for Oracle v1.50 release notes
Devart
© 1997 - 2025 Devart. All rights reserved.