dbForge Fusion for Oracle
  • Documentation center

  • Table of Contents

  • Get started
    • Compatibility
    • Copyright Information
    • Installing dbForge Fusion for Oracle
    • Uninstalling dbForge Fusion for Oracle
    • Connecting to a Database
    • Creating and Editing a Query
    • Creating a Query in Query Builder
    • Editing Data
    • Creating a Table in Table Editor
    • Back up a Database
  • Connecting to Databases
    • Managing Database Connections
    • Viewing Database Schema Information
  • Writing and Executing SQL Statements
    • SQL Document Overview
    • Writing SQL Statements
    • Executing SQL Statements
    • Working with Code Snippets
    • Working with Literals
    • Viewing Server Messages and Errors
    • Using Parameters
    • SQL History
    • Executing Large Scripts
    • Opening Large Scripts in SQL Editor
    • Associating Windows with Connection
    • SQL*Plus Command Support
  • 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 Query in Visual Mode
    • Navigating Query with Document Outline
  • Working with Query Diagram
    • Diagram Overview
    • Diagram Layout
    • Aligning Shapes
    • Chaging 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
    • Sorting Data in Grid
    • Grouping Data in Grid
    • Filtering Data in Grid
    • Server-Side and Client-Side Sorting and Filtering
    • Paginated Mode
    • Auto-search Mode
    • Card View
    • Editing Data in Grid
    • Using Transactions
    • Cached Updates
    • Foreign Key Lookup
  • Working with Subqueries
    • Subqueries Overview
    • Subqueries in From Clause
    • Subqueries in Other Clauses
  • Exporting and Importing Data
    • Data Export
    • How to Export Data
    • Saving and Using Templates During Data Export
    • Data Import
    • MS Access Import
    • CSV Import
    • DBF Import
    • MS Excel Import
    • Text Import
    • XML Import
    • Migrating Data from Other Servers
    • Saving and Using Templates During Import
    • Importing Data To New Table
  • Working with Pivot Table
    • What is Pivot Table
    • Creating Pivot Table
    • Creating Chart in Pivot Table
    • Reordering Fields in Pivot Table
    • Filtering Fields in Pivot Table
    • Sorting Fields in Pivot Table
    • Grouping Fields in Pivot Table
    • 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 Master-Detail Tables
    • 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 Tables
    • Creating, Droping, and Editing Tables
    • Defining Table Structure
    • Unique and Primary Keys
    • Check Constraints
    • Foreign Keys
    • Object Tables
    • Clustered Tables
    • Index-Organized Tables
    • Views
  • Partitioned 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 Subpartitions
    • Using Subpartition Template
  • PL/SQL Objects
    • Procedures and Functions
    • Package Specification
    • Package Body
    • Packages and Programs Compilation
    • Object Type Specification
    • Object Type Body
    • Database Links
    • Materialized View
    • Materialized View Logs
    • Collection Types
    • Clusters
    • Sequences
    • Synonyms
    • Triggers
    • XML Objects
  • Schema Objects Walkthrough
    • Creating a Copy of Schema Object
    • Displaying the Number of Schema 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 for Schema Objects
    • Searching Table and View Data
    • Manage Search Results
  • Designing Databases with Database Designer
    • Creating Database Diagram
    • Adding Database Objects to Diagram
    • Deleting and Editing Database Objects on Diagram
    • Creating Many-to-Many Relationship Between Tables
    • Saving and Restoring a Diagram
    • Exporting a Diagram
    • Printing a Diagram
    • Searching Text on Database Diagram
    • Setting Diagram Options
    • Additional Elements on Diagram
  • Working with Database Objects on Diagram
    • Editing Tables
    • Displaying Database Objects on Diagram
    • Working with Relations
    • Relation Notations
    • Diagram Shapes and Layout
  • Exporting and Importing Oracle Schemas
    • Copying Oracle Schema
    • Schema Export and Import
    • Oracle Administrative Privileges for Connection to Server
  • Managing Users and Privileges
    • User Management Concepts
    • Setting Up New User Account
    • Manipulating User Accounts
    • Working With Privileges
    • Manipulating Roles
    • Granting and Revoking Roles
    • Manipulating Profiles
    • Working with Multiple Users
    • Generating DDL
    • Duplicationg Security Objects
    • Watermarks in Security Manager
  • Debugging PL/SQL Units
    • Debugger Overview
    • Debugging Stored Procedure
    • Debugging Stored Function
    • Debugging a Trigger
    • Start Debugging Object Method
    • Start Debugging Package
    • Debugging SQL Script
    • Execution Control
    • Working with Breakpoints
  • 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
    • Groupng and Filtering Comparison Results
    • Comparing Objects DDL
    • Previewing Schema Synchronization Script
    • Generating Comparison Report
    • Synchronizing Schemas
    • Schema Comparison and Synchronization Overview
    • Viewing Schema Differences
    • Comparing and Synchronizing Schemas on Different Server Versions
    • Known Schema Comparison Problems
    • Creating Snapshot in Schema Compare
  • 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
    • Synchronizing Warnings
    • Type Compatibility Table
    • Data Comparison Process
    • Data Synchronization Process
    • Creating a Snapshot in Data Compare
  • Performing Administration Tasks
    • Using Export and Import Utility Wizards
    • Retrieving Information about Current Session
    • Using Cursor List
    • Terminating and Disconnecting Session
    • Enabling and Disabling SQL Trace
    • Alerts and Pipe Messages
    • Controlling Sessions
    • Receiving and Sending Alerts and Pipe Messages
  • Developing Database Projects
    • Creating 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 Static Report
    • Creating Simple Data-Aware Report
    • Creating Master-Detail Report
    • Saving and Loading Reports
    • Exporting Data Reports
    • Data Reports Overview
    • Report Building Basics
    • Designer Elements
    • Measure Units
    • Report Bands
    • Report Controls
    • Smart Tags
    • Context Links
  • User Interface Concepts
    • User Interface Elements
    • Document Views
    • Customizing User Shortcuts
    • Importing and Exporting Settings
  • Release notes and other versions
    • What's New in dbForge Fusion for Oracle, v3.10
    • What's New in dbForge Fusion for Oracle, v3.9
    • What's New in dbForge Fusion for Oracle, v3.8
    • What's New in dbForge Fusion for Oracle, v3.7
    • What's New in dbForge Fusion for Oracle, v3.6
    • What's New in dbForge Fusion for Oracle, v3.5
    • What's New in dbForge Fusion for Oracle, v2.6
    • What's New in dbForge Fusion for Oracle, v2.5
    • What's New in OraDeveloper Tools, v2.0
    • What's New in OraDeveloper Tools, v1.70
    • What's New in OraDeveloper Tools v1.50
Devart
© 1997 - 2025 Devart. All rights reserved.