New Features for Oracle Developer Tools for Visual Studio Release 11.1.0.6.20

Oracle Developer Tools for Visual Studio release 11.1.0.6.20 includes the following:

• Integration with Visual Studio 2005

  • Integration with Server Explorer in Visual Studio 2005

    The Oracle Developer Tools are now fully integrated with Microsoft Server Explorer.

    Note: Oracle Explorer is no longer available in Visual Studio 2005. Its functionality has been replaced by Server Explorer.

    See Also: About Server Explorer

  • Integration with Visual Studio 2005 designers and wizards

    This release is fully integrated with Microsoft data designers including Query Designer.

    See Also: Integration with Query Designer

• Oracle Database Project with Source Control Integration

  Oracle Database Project is a Visual Studio project type that enables you to manage SQL scripts, providing the ability to edit and run them, as well as checking them into source control.

  See Also: About Oracle Database Project

• Run SQL*Plus Dialog

  This dialog enables you to run any SQL script even those that are not included in an Oracle Database project.

  See Also: Run SQL*Plus Script Dialog

• Support for User-Defined Types (UDTs)

  All user-defined types defined in the database can be viewed in the Server Explorer tree controls. Designers have been added for Objects, VARRAYs, and Nested Table Types.

  <div class="infoboxnote" markdown="1">
  
  **See Also:**
  
  - [User-Defined Types Node](User-Defined_Types_Node.html#GUID-A782926E-1ADA-4A48-8D62-98E820474B79)
  
  - [Object Type Nodes](Object_Type_Node.html#GUID-156E76FB-CEA7-4E22-832D-CD398233964E)
  
  - [Object Type Body Nodes](Object_Type_Body_Node.html#GUID-93C8F04B-5461-4882-B5C8-374AAA596E3D)
  
  - [Object Type Attribute Nodes](Object_Attribute_Node.html#GUID-3090625C-7700-4E73-88BD-6871EE80A377)
  
  - [Object Method Nodes](Object_Method_Node.html#GUID-D1921C75-25FE-44CC-B87D-A3E7DF9C5D1F)
  
  - [VARRAY Type Nodes](VARRAY_Node.html#GUID-53787116-5CB0-4751-AE57-F66CAB314719)
  
  - [Oracle Custom Class Wizard](Oracle_Custom_Class_Wizard.html#GUID-C55ECA2D-4A8E-4E1A-8C24-CFD3B769886F)
  
  - [Object Type Designer](Object_Type_Designer.html#GUID-60F0765E-5776-4113-8073-2A4742818E66)
  
  - [Varray Designer](Varray_Designer.html#GUID-5FDA255C-62E6-41F8-9585-F3F1D6A61885)
  
  - [Nested Table Type Designer](Nested_Table_Designer.html#GUID-552AD4E1-AF55-40CB-8E10-872A3F2F0B50)
  
  </div>
  

• Query Window enhancements

  Query Window enhancements support EXPLAIN PLAN functionality, auto-commit toggle mode, and shortcut keys.

  See Also:

  • Enabling and Disabling Autocommit

• Data Window Enhancements

  The data window now has an options page that allows the user to restrict the number of rows fetched and displayed.

  See Also: General Options Page

• A new dialog for granting and revoking privileges for schema objects.

  See Also: Grant/Revoke Privileges Dialog

• PL/SQL Debugging Enhancements

  The PL/SQL debugger now supports the autos windows in Visual Studio.

  See Also: Autos Window

• Import Table Wizard

  This wizard makes it easy to move tables and their data from external data sources such as Microsoft SQL Server, Microsoft Access, and Excel spreadsheets.

  See Also: Import Table Wizard