1. Getting Started with Oracle Developer Tools for VS Code
  2. Getting Started with Oracle Developer Tools for VS Code
  3. Changing the Default Schema for a Connection

Changing the Default Schema for a Connection

To use a different schema than the default for the user you logged in as (for example, you logged in as ADMIN but want to default to using the HR schema when executing SQL or when browsing with Oracle Explorer), follow the steps in Connecting to Oracle Database or Connecting to Oracle Autonomous Database (ADB) to open the connection dialog and provide the connection information.

  • In the connection dialog, check the Show more options checkbox and then select a different schema in the Current Schema dropdown.

Parent topic: Getting Started with Oracle Developer Tools for VS Code