Chat now with support
Chat with Support

Toad for Oracle 12.11 - Getting Started Guide

Table of Contents Welcome to Toad Toad Resources Required Privileges Create and Manage Database Connections Editor Basics Schema Browser Basics Data Grid Basics Work with Data Work with Database Objects Work with Code
Write Statements and Scripts Work with the Query Builder Execute Statements and Scripts Save Statements (SQL Recall) Work with PL/SQL Objects Debug Analyze Code Optimize SQL
Customize your Toad Environment Use Other Quest Software Products with Toad

Compare Data Duplicates

Work with Data > Compare Data Duplicates

Use this dialog box to view record duplicates based on user input.

To view record duplicates

  1. Select Database | Compare | Data Duplicates
  2. Select the Owner, Object Type and Object from the drop-down lists. A list of columns is displayed below.
    Now, you can either:

    Find duplicates on all columns

    Check the Find duplicates on all columns option button.

    Do not select any columns in the list.

    Find duplicates on just selected columns

    Check the Find dupes of selected columns option button.

    Select one or more columns in the column list.

    On the Duplicate Data tabs, an additional column called Occurences is added to the end of the grid to display the number of resulting duplicates.

To edit duplicate data

  1. From the Table Data Duplicates window, select Owner and Table from the drop-down lists.
  2. Click the Duplicate Data (Editable) tab.
  3. Click the cell you want to edit and make your changes.
  4. Click on the toolbar.

 

Insert/Delete Rows

Work with Data > Insert/Delete Rows

The dataset must be editable for you to make any changes. Understand Editable Resultsets

To insert a blank row

Click on the data grid toolbar.

To copy an existing row

Right-click the cell you want to copy and select Duplicate Row. If you have a sequence set, then the sequence number advances when you finish editing.

To delete a row

Click on the data grid toolbar.

 

Post/Revert Edited Data

Work with Data > Post/Revert Edited Data

The dataset must be editable for you to make any changes. Understand Editable Resultsets

To post data

  1. Make changes to an editable resultset in the data grid.
  2. Click in the grid navigator.

To revert data

Click in the grid navigator.

 

Edit Data in Popup Editor

Work with Data > Edit Data in Popup Editor

You can view and edit data in a Popup Editor. This feature is helpful when there is too much data to view in the data grid.

Note: The dataset must be editable for you to make any changes. Understand Editable Resultsets

To edit data in the Popup Editor

Right-click a cell in the data grid and select Popup Editor.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating