Chat now with support
Chat with Support

Toad for Oracle 12.12 - 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

Find in Objects

  • From the main toolbar, click .
  • From the Search menu, select Object Search

Copy Objects to Another Schema

You can copy objects to another schema.

To copy objects to another schema

  1. Click image\Toad0015.gif on the Standard toolbar to open the Schema Browser.
  2. Right-click the object you want to copy in the left-hand side and select Create in another schema.
  3. Select export settings and click OK. See Export DDL in the online help for more information.
  4. Enter the destination connection and destination schemas.
  5. To review the script to create the objects, click the Script tab.
  6. Click Execute.

 

Create or Alter Objects

Toad lets you select Oracle object parameters and generate a DDL statement to create or alter objects. It is generally a good idea to review the DDL statement before executing it. When you execute the statement, Toad passes it to the database, and the object is created or altered.

The options to create or alter an object in Toad follow the parameters defined by Oracle. If you need clarification on what an option means or how it should be used, see Oracle's documentation for more information. Oracle provides detailed documentation about objects, including their purpose, properties, and restrictions.

Notes:

  • Toad strictly adheres to the database security. Consult your DBA to learn what privileges you have.
  • You can also find detailed information about parameters in Knowledge Xpert. Knowledge Xpert is an extensive Oracle technical resource which you can search in Jump search. Jump Search
  • You can use an existing object as a template when creating a new one. Use Existing Object as Template for New Objects

To create an object

  1. Click image\Toad0015.gif on the Standard toolbar to open the Schema Browser.
  2. Right-click on the object type in the left-hand side and select .

    Note: You can also create an object by selecting Database | Create | <Object type>.

  3. Complete the fields as necessary.

  4. To add the object to the Project Manager, select Add to Project Manager.
  5. To view the CREATE statement, click Show SQL or select the SQL tab.
  6. Click OK or Execute to create the object immediately. You can also schedule the script to run later.

To alter an object

To alter or edit an object, double-click on it in the Schema Browser. To rename an object (if permitted) press F2.

Note: You cannot make any changes on the Alter Index | Column tab because Oracle does not permit an index to be altered that way. To alter an index, send the script to the editor (with a DROP command), edit the script, and then run it. As an alternative, you can right-click the index then choose Create Like. Enter a name for the new index, make the changes, and then drop the original index.

 

Use Existing Object as Template for New Objects

You can use an existing object as a template for creating a new object. Toad loads the original object's properties in the Create window for you to edit as necessary and execute.

Note: This feature is not available for all object types.

To create an object based on an existing one

  1. Click image\Toad0015.gif on the Standard toolbar to open the Schema Browser.
  2. Right-click the object you want to use as a template in the left-hand side and select Create Like.
  3. Complete the fields as necessary.
  4. To view the CREATE statement, click Show SQL or select the SQL tab.
  5. Click OK or Execute to create the object immediately. You can also schedule the script to run later.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating