Title and Copyright Information
Preface
- Audience
- Documentation Accessibility
- Passwords in Code Examples
- Conventions
Oracle Developer Tools for Visual Studio Release Notes
Changes in This Release for Oracle Developer Tools for Visual Studio
- New Features for Oracle Developer Tools for Visual Studio Release 23.26.0
- New Features for Oracle Developer Tools for Visual Studio Release 23.8
- New Features for Oracle Developer Tools for Visual Studio Release 23.6
- New Features for Oracle Developer Tools for Visual Studio Release 21.7.0.0.0
- New Features for Oracle Developer Tools for Visual Studio Release 19.3
- New Features for Oracle Developer Tools for Visual Studio Release 12.2.0.1.0
- New Features for Oracle Developer Tools for Visual Studio Release 12.1.0.2.4
- New Features for Oracle Developer Tools for Visual Studio Release 12.1.0.2.0
- New Features for Oracle Developer Tools for Visual Studio Release 12.1.0.1.2
- New Features for Oracle Developer Tools for Visual Studio Release 12.1.0.1.0
- New Features for Oracle Developer Tools for Visual Studio Release 11.2.0.3.20
- New Features for Oracle Developer Tools for Visual Studio Release 11.2.0.3.1
- New Features for Oracle Developer Tools for Visual Studio Release 11.2.0.1.2
- New Features for Oracle Developer Tools for Visual Studio Release 11.1.0.7.20
- New Features for Oracle Developer Tools for Visual Studio Release 11.1.0.6.20
- New Features for Oracle Developer Tools for Visual Studio Release 10.2.0.2
Welcome
- Welcome to Oracle Developer Tools for Visual Studio
  - Oracle Developer Tools Functionality
  - Get Help, Provide Feedback, and Report Issues
- Requirements
  - System Requirements
- Related Documentation
Setting Up
- About Setting Up
- Connecting to Oracle Database from Visual Studio
- Oracle Developer Tools Options Pages
Integration with Server Explorer
- About Server Explorer
- About Server Explorer Integration
- What is Server Explorer Integration?
- Object View and Schema View
- Refreshing Nodes
- Performing Operations on Multiple Database Objects at Once
- Avoiding Performance Problems Due to Large Collections of Database Object Nodes
  - Filtering Collection Nodes
  - Filtering the Displayed Schema
  - Filtering Public Synonyms
  - Changing the Visibility of Collection Types
  - Limiting the Number of Objects Displayed in a Collection Node
- Oracle Cloud Infrastructure Node
  - About the Oracle Cloud Infrastructure Node
  - How the Oracle Cloud Infrastructure Node Works
  - Menu Options
- Oracle Cloud Infrastructure Profile Nodes
  - About the Oracle Cloud Infrastructure Profile Node
  - How the Oracle Cloud Infrastructure Accounts Profile Works
  - Menu Options
- Transaction Processing/Lakehouse/JSON Node
  - About the Transaction Processing/Lakehouse/JSON Node
  - How the Transaction Processing/Lakehouse/JSON Node Works
  - Menu Options
- Transaction Processing/Lakehouse/JSON Nodes
  - About the Transaction Processing/Lakehouse/JSON Nodes
  - How the Transaction Processing/Lakehouse/JSON Nodes Works
  - Menu Options
- Data Connections Options Page
  - Using the Data Connections Options Settings
- Data Connections Node
  - How the Data Connections Node Works
  - Menu Options
- Data Connection Nodes
  - How the Data Connection Node Works
    - Viewing Database Objects
  - Menu Options
- Pluggable Databases Node
  - About Pluggable Databases
  - How the Pluggable Databases Node Works
  - Menu Options
- Pluggable Database Nodes
  - About Pluggable Database Nodes
  - How the Pluggable Database Nodes Work
  - Menu Options
- Schemas Node
  - About Schemas
  - How the Schemas Node Works
  - Menu Options
- Schema Nodes
  - How the Schema Nodes Work
  - Menu Options
- Tables Node
  - About Tables Node
  - How the Tables Node Works
  - Menu Options
- Relational Tables Node
  - About Relational Tables node
  - How the Relational Tables node Works
  - Menu Options
- Object Tables Node
  - About Object Tables Node
  - How the Object Tables node Works
  - Menu Options
- XML Tables Node
  - About XML Tables Node
  - How the XML Tables node Works
  - Menu Options
- Table Nodes
  - How Table Nodes Work
  - Menu Options
- Table Column Node
  - How the Table Column Nodes Work
  - Menu Options
- Constraints Node
  - About Constraints
  - How the Constraints Node Works
  - Menu Options
- Constraint Nodes
  - How Constraint Nodes Work
  - Menu Options
- Indexes Node
  - About Indexes
  - How the Indexes Node Works
  - Menu Options (child of Data Connection Node)
  - Menu Options (child of Table Node)
- Index Nodes
  - How the Index Nodes Work
  - Menu Options
- Triggers Node
  - About Triggers
  - How the Triggers Node Works
  - Menu Options (child of Data Connection Node)
  - Menu Options (child of Table Node)
- Table Triggers Node
  - About Table Triggers Node
  - How the Table Triggers Node Works
  - Menu Options
- View Triggers Node
  - About View Triggers Node
  - How the View Triggers Node Works
  - Menu Options
- Schema Triggers Node
  - About Schema Triggers Node
  - How the Schema Triggers Node Works
  - Menu Options
- Database Triggers Node
  - About Database Triggers Node
  - How the Database Triggers Node Works
  - Menu Options
- Trigger Nodes
  - How the Trigger Nodes Work
  - Menu Options
- Views Node
  - About Views
  - How the Views Node Works
  - Menu Options
- Relational Views Node
  - About Relational Views Node
  - How the Relational Views Node Works
  - Menu Options
- Object Views Node
  - About Object Views Node
  - How the Object Views Node Works
  - Menu Options
- XML Views Node
  - About XML Views Node
  - How the XML Views Node Works
  - Menu Options
- Materialized Views Node
  - About Materialized Views Node
  - How the Materialized Views Node Works
  - Menu Options
- View Nodes
  - How the View Nodes Work
  - Menu Options
- View Column Node
  - How the View Column Node Works
  - Menu Options
- Procedures Node
  - About Procedures
  - How the Procedures Node Works
  - Menu Options
- Procedure Nodes
  - How the Procedure Nodes Work
  - Menu Options
- Functions Node
  - About Functions
  - How the Functions Node Works
  - Menu Options
- Function Nodes
  - How Function Nodes Work
  - Menu Options
- Parameter Nodes for Procedures, Functions, Package Methods, and Object Type Methods
  - How the Parameter Nodes Work
  - Menu Options
- Function Node: Return Value Node
  - How Function Return Value Nodes Work
  - Menu Options
- Packages Node
  - About Packages
  - How the Packages Node Works
  - Menu Options
- Package Nodes
  - How the Package Nodes Work
  - Menu Options
- Package Function Nodes
  - How the Package Function Nodes Works
  - Menu Options
- Package Procedure Nodes
  - How the Package Procedure Nodes Works
  - Menu Options
- Package Body Nodes
  - About the Package Body
  - How the Package Body Node Works
  - Menu Options
- Parameter Nodes for Procedures, Functions, Package Methods, and Object Type Methods
  - How the Parameter Nodes Work
  - Menu Options
- Synonyms Node
  - About Synonyms
  - How the Synonyms Node Works
  - Menu Options
- Synonym Nodes
  - How Synonym Nodes Work
  - Menu Options
- Sequences Node
  - About Sequences
  - How the Sequences Node Works
  - Menu Options
- Sequence Nodes
  - How Sequence Nodes Work
  - Menu Options
- XML Database Node
  - About XML Databases
  - How the XML Database Node Works
  - Menu Options
- XML Schemas Node
  - About XML Schemas
  - How the XML Schemas Node Works
  - Menu Options
- XML Schema Nodes
  - How XML Schema Nodes Work
  - Menu Options
- Java Classes Node
  - About Java Classes
  - How the Java Classes Node Works
  - Menu Options
- Java Class Nodes
  - How Java Class Nodes Work
  - Menu Options
- User-Defined Types Node
  - About User-Defined Types Node
  - How User-Defined Types Work
  - Menu Options
- Users Node
  - About Users Node
  - How the Users Node Works
  - Menu Options
- User Nodes
  - How the User Nodes Work
  - Menu Options
- Roles Node
  - About Roles
  - How Roles Work
  - Menu Options
- Role Nodes
  - How Role Nodes Work
  - Menu Options
- Object Type Nodes
  - About Object Type Nodes
  - Menu Options
- Object Type Body Nodes
  - About Object Type Body Nodes
  - How Object Type Body Nodes Work
  - Menu Options
- Object Type Attribute Nodes
  - About Object Type Attribute Nodes
  - Menu Options
- Object Method Nodes
  - About Object Method Nodes
  - Menu Options
- VARRAY Type Nodes
  - About VARRAY Type Nodes
  - How VARRAY Type Nodes Work
  - Menu Options
- Nested Table Type Nodes
  - About Nested Table Type Nodes
  - How Nested Table Type Nodes Work
  - Menu Options
- Advanced Queues Node
  - About Advanced Queues Node
  - How Advanced Queues Node Works
  - Menu Options
- Queues Node
  - About the Queues Node
  - How the Queues Node Works
  - Menu Options
- Queue Nodes
  - About Queue Nodes
  - How Queue Nodes Work
  - Menu Options
- Subscribers Node
  - About the Subscribers Node
  - How the Subscribers Node Works
  - Menu Options
- Subscriber Nodes
  - About Subscriber Nodes
  - How the Subscriber Nodes Work
  - Menu Options
- Propagations Node
  - About Propagations Node
  - How the Propagations Node Work
  - Menu Options
- Propagation Nodes
  - About Propagation Nodes
  - How the Propagation Nodes Work
  - Menu Options
- Queue Tables Node
  - About Queue Tables Node
  - How Queue Tables Node works
  - Menu Options
- Queue Table Nodes
  - About Queue Table Nodes
  - How Queue Table Nodes Work
  - Menu Options
- ADDM Tasks Node
  - About ADDM Tasks
  - How the ADDM Tasks Node Works
  - Menu Options
- ADDM Task Nodes
  - How ADDM Task Nodes Work
  - Menu Options
- AWR Snapshots Node
  - About AWR Snapshots
  - How the AWR Snapshots Node Works
  - Menu Options
- AWR Snapshot Nodes
  - How AWR Snapshot Nodes Work
  - Menu Options
Wizards, Designers, and Dialogs
- About Wizards, Designers, and Dialogs
  - Common Dialog Box Functionality
  - Naming Convention for Schema Names
- Connection Dialog Box
  - Opening the Connection Dialog Box
  - Using the Connection Dialog Box
  - Advanced Properties Dialog Box
  - Filters Tab
  - HTTPS Proxy Tab
  - Connection Configuration Options Page
    - Accessing the Connection Configuration Options Page
    - Using the Connection Configuration Options Page
- Oracle Server Login Dialog
- Preview SQL Dialog
  - Using Preview SQL
- Table Designer
  - Creating Tables in Oracle Developer Tools
  - Starting the Table Designer
  - Using the Table Designer
  - Main Window
  - Columns Tab
  - Constraints Tab
  - Indexes Tab
  - XML Tab
  - Object Tab
- Import Table Wizard
  - Starting the Import Table Wizard
  - Using the Import Table Wizard
- Trigger Designer
  - Creating Triggers in Oracle Developer Tools
  - Starting the Trigger Designer
  - Using the Trigger Designer
- View Designer
  - Creating Views in Oracle Developer Tools
  - Starting the View Designer
  - Using the View Designer
  - Creating Triggers on Existing Views
- Function Designer
  - Creating Functions in Oracle Developer Tools
  - Starting the Function Designer
  - Using the Function Designer
- Procedure Designer
  - Creating Procedures in Oracle Developer Tools
  - Starting the Procedure Designer
  - Using the Procedure Designer
- Stored Procedure Run Dialog Box
  - Running Procedures and Functions in Oracle Developer Tools
  - Starting the Run Dialog Box
  - Using the Run Dialog Box
  - Viewing the Results from Running a Procedure or Function
  - Using the Run Dialog Results Window
- Package Designer
  - Creating Packages in Oracle Developer Tools
  - Starting the Package Designer
  - Using the Package Designer
  - Add Method Dialog Box
- Sequence Designer
  - Creating Sequences in Oracle Developer Tools
  - Starting the Sequence Designer
  - Using the Sequence Designer
- Synonym Designer
  - Starting the Synonym Designer
  - Using the Synonym Designer
- XML Schema Designer
  - Starting the XML Schema Designer
  - Using the XML Schema Designer
- Object Type Designer
  - Creating Object Types in Oracle Developer Tools
  - Starting the Object Type Designer
  - Using the Object Type Creation Designer
- Varray Designer
  - Creating VARRAYs in Oracle Developer Tools
  - Starting the VARRAY Designer
  - Using the VARRAY Designer
- Nested Table Type Designer
  - Creating Nested Tables in Oracle Developer Tools
  - Starting the Nested Table Designer
  - Using the Nested Table Designer
- OracleDataAdapter Wizard
  - Starting the OracleDataAdapter Wizard
  - Using the OracleDataAdapter Wizard
  - Configuring Parameters for Statements
- Oracle Custom Class Wizard
  - Starting the Oracle Custom Class Wizard
  - Using the Oracle Custom Class Wizard
    - Languages in the Oracle Custom Class Wizard
  - Generating Classes with the Oracle Custom Class Wizard
- Integration with Query Designer
- User Designer
  - Starting the User Designer
  - Using the User Designer
- Role Designer
  - Creating a Role in Oracle Developer Tools
  - Starting the Role Designer
  - Using the Role Designer
- Grant/Revoke Privileges Dialog
  - About the Grant/Revoke Privileges Dialog
  - Starting the Grant/Revoke Privilege Dialog
  - Using the Grant/Revoke Dialog
- Run SQL*Plus Script Dialog
  - Running the Run SQL*Plus Script Dialog
  - Using Run SQL*Plus Script
- Oracle Database Project Run On Dialog
- Oracle Database Project Add Database Reference Dialog
- Queue Table Designer
- Starting the Queue Table Designer
  - Using the Queue Table Designer
  - Main Window
  - Queue Table Designer Options Tab
- Queue Designer
- Starting the Queue Designer
  - Using the Queue Designer
  - Main Window
  - Options Tab
  - Queue Table Tab
  - Subscribers Tab
  - Propagation Tab
- Oracle Performance Analyzer
  - Starting the Oracle Performance Analyzer
  - Performance Analysis Tab
- New ADDM Task Dialog
  - Creating a New ADDM Task
  - Starting a New ADDM Task Dialog
  - Using the New ADDM Task Dialog
- New AWR Snapshot Dialog
  - Creating a New AWR Snapshot
  - Starting the New AWR Snapshot Dialog
  - Using the New AWR Snapshot Dialog
- Schema Compare Source and Target Dialog
  - Opening the Schema Compare Source and Target Dialog
  - Using Schema Compare Source and Target Dialog
- Schema Compare Results Window
  - Opening the Schema Compare Results Window
  - Using the Schema Compare Results Window
- New Pluggable Database Dialog
  - Starting the New Pluggable Database Dialog
  - Using the New Pluggable Database Dialog
- Clone Pluggable Database Dialog
  - Starting the Clone Pluggable Database Dialog
  - Using the Clone Pluggable Database Dialog
- Plug Pluggable Database Dialog
  - Starting the Plug Pluggable Database Dialog
  - Using the Plug Pluggable Database Dialog
- Unplug Pluggable Database Dialog
  - Starting the Unplug Pluggable Database Dialog
  - Using the Unplug Pluggable Database Dialog
- Open Pluggable Database Dialog
  - Starting the Open Pluggable Database Dialog
  - Using the Open Pluggable Database Dialog
- Close Pluggable Database Dialog
  - Starting the Close Pluggable Database Dialog
  - Using the Close Pluggable Database Dialog
- Query Parameters Dialog
  - Starting the Query Parameters Dialog
  - Using the Query Parameters Dialog
- Grant Debugging Privileges Dialog
  - Starting the Grant Debugging Privileges Dialog
  - Using the Grant Debugging Privileges Dialog
  - Revoking Privileges
- Import Schema Dialog
  - Opening the Import Schema Dialog
  - Using the Import Schema Dialog
- Dependencies and References Viewer
- Dependency Viewer Options Page
- Change Compartment or Region Dialog
  - Opening the Change Compartment or Region Dialog
  - Using the Change Compartment or Region Dialog
- Create Autonomous AI Database Dialog
  - Opening the Create Autonomous AI Database Dialog
  - Using the Create Autonomous AI Database Dialog
- Scale Up/Down Dialog
  - Opening the Scale Up/Down Dialog
  - Using the Scale Up/Down Dialog
- Change Administrator Password Dialog
  - Opening the Change Administrator Password Dialog
  - Using the Change Administrator Password Dialog
- Download Credentials Files Dialog
  - Opening the Download Credentials Files Dialog
  - Using the Download Credentials Files Dialog
- Copy Credentials Files Dialog
  - Opening the Copy Credentials Files Dialog
  - Using the Copy Credentials Files Dialog
- Restore Database Dialog
  - Opening the Restore Database Dialog
  - Using the Restore Database Dialog
- Update License Type Dialog
  - Opening the Update License Type Dialog
  - Using the Update License Type Dialog
- Configure Walletless Connectivity and Network Access Dialog
  - Opening the Configure Walletless Connectivity and Network Access Dialog
  - Using the Configure Walletless Connectivity and Network Access Dialog
- Get Connection Strings Dialog
  - Opening the Get Connection Strings Dialog
  - Using the Get Connection Strings Dialog
- Update Access Control Dialog
  - Opening the Update Access Control Dialog
  - Using the Update Access Control Dialog
- Select Compartment Dialog
  - Opening the Select Compartment Dialog
  - Using the Select Compartment Dialog
- Real-Time SQL Monitor Window
  - Opening the Real-Time SQL Monitor Window
  - Using the Real-Time SQL Monitor Window
- Active Report Window
  - Opening the Active Report Window
  - Using the Active Report Window
- Configure Select AI Provider Network Access Dialog
  - Opening the Configure Select AI Provider Network Access Dialog
  - Using the Configure Select AI Provider Network Access Dialog
- Configure Select AI Profile Dialog
  - Opening the Configure Select AI Profile Dialog
  - Using the Configure Select AI Profile Dialog
- Select AI Object List Dialog
  - Opening the Select AI Object List Dialog
  - Using the Select AI Object List Dialog
- Set Default AI Profile For Connection Dialog
  - Opening the Set Default AI Profile For Connection Dialog
  - Using the Set Default AI Profile For Connection Dialog
Oracle Data Window
- About Oracle Data Window
- General Options Page
  - Accessing General Options Page
  - Using the General Options Setting
PL/SQL Code Editor
- About PL/SQL Code Editor
- Starting the PL/SQL Code Editor
- Using PL/SQL Code Editor
  - PL/SQL Code Editor Features
- PL/SQL Compiler Settings Options Page
Oracle PL/SQL Debugger
- About the Oracle PL/SQL Debugger
- PL/SQL Debugging Setup
- PL/SQL Debugging Options
- Debugger Modes
- Direct Database Debugging Mode
- Multitier Application Debugging Mode
- External Application Debugging Mode
- Common PL/SQL Debugger Operations
- PL/SQL Program Refresh Behavior
- Controlling PL/SQL Program Execution
- Using Breakpoints
- Examining Debug Information
- Handling PL/SQL Exceptions
- Troubleshooting the Debugger
SQL and PL/SQL File Editor
- About SQL and PL/SQL File Editor
  - Opening SQL and PL/SQL File Editor
  - Executing SQL Statements Using SQL and PL/SQL File Editor
- SQL and PL/SQL File Editor Menu Options
- IntelliSense Settings Options Page
  - Accessing the IntelliSense Settings Options Page
  - Using the IntelliSense Settings Options Page
- Query Execution Settings
  - Accessing the Query Execution Settings
  - Using the Query Execution Settings
- Explain Plan Settings
  - Accessing the Explain Plan Settings
  - Using the Explain Plan Settings
- SQL and PL/SQL Formatter Settings
  - Accessing the SQL and PL/SQL Formatter Settings
  - Using the SQL and PL/SQL Formatter Settings
Using Select AI: Natural Language to SQL
- About Select AI
- Configuring Select AI for First Use
- Setting an AI Profile on a Database Connection
- Translating and Executing Natural Language Queries
Oracle Database Project
- About Oracle Database Project
- Creating the Oracle Database Project
  - Adding Database References
  - Viewing Oracle Database Project in Solution Explorer
- About Database Project Nodes and Folders
- Oracle Database Project Node
- Oracle Database Project Folders
  - Menu Options
  - Properties
- Project Script Files
  - Menu Options
  - Properties
- Database References Node
- Database Reference Nodes
  - Menu Options
  - Properties
- Managing Oracle Script Files
- Source Control Integration
- Upgrading a Database Project from Earlier Versions
- About Editing Oracle SQL Scripts
- About Running Oracle SQL Scripts
Oracle Database Project Version 2
- About Oracle Database Project Version 2
- Creating the Oracle Database Project Version 2
  - Viewing Oracle Database Project Version 2 in Solution Explorer
- About Database Project Folders and Project Items
- Oracle Database Project Version 2 Project Folder
- Oracle Database Project Version 2 Folders
  - Menu Options
  - Properties
- Project Script Files
  - Menu Options
  - Properties
- Database References Folder
- Database Reference Project Items
  - Menu Options
  - Properties
- Managing Oracle Script Files
- Source Control Integration
- About Editing Oracle SQL Scripts
- About Running Oracle SQL Scripts
Oracle Streams Advanced Queueing
- About Oracle Streams Advanced Queueing
- Setting Up
- AQ Server Explorer Nodes
- AQ Designers
Users, Roles, and Privileges
- About Users, Roles, and Privileges
- Managing Users
- Managing Roles
- Granting Privileges to Roles and Users
Performance Tuning
- Performance Tuning Overview
- About Oracle Performance Analyzer
  - Privileges
  - Licensing
- Oracle Performance Analyzer Interface
- Using the Oracle Performance Analyzer
- About SQL Tuning Advisor
  - Privileges
  - Licensing
- About Real-Time SQL Monitor
Using Entity Framework Designer
- About Entity Framework
- Requirements for using Entity Framework Designer
- Visual Studio Entity Designer
- Entity Designer Settings Options
  - Accessing Entity Designer Settings Options Page
  - Using the Entity Designer Settings Options
Schema Compare
- About Schema Compare
- Using Schema Compare
- Schema Compare Options
Multitenant Container Databases
- About Multitenant Container Databases
- Using CDBs
- Connecting to a PDB in Server Explorer
- PDB and CDB Compatibility
Troubleshooting
- About Troubleshooting
- Logging Settings
  - Accessing the Logging Settings
  - Using the Logging Settings

Table of Contents