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.

  See Also:

  • User-Defined Types Node

  • Object Type Nodes

  • Object Type Body Nodes

  • Object Type Attribute Nodes

  • Object Method Nodes

  • VARRAY Type Nodes

  • Oracle Custom Class Wizard

  • Object Type Designer

  • Varray Designer

  • Nested Table Type Designer

• Query Window enhancements

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

  See Also:

  • Enabling and Disabling Autocommit

  • Examining the Execution Plan of a SQL Statement

• 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