#Oracle sql studio how to#

In this exercise, it will be HR.orcl.ĭescription of the illustration addconnection2.gifĬlick the Apply Filters tab, and verify that the HR schema is in the Displayed schemas column. The Connection name should be generated automatically from the Data source name and the User name values.

This refers to the default roles that have been granted to the user hr. To save the password for future sessions, check the Save password box.Įnsure that Role is set to Default. Select the Use a specific user name and password option.įor Password, enter the password created when the hr account was unlocked and set up. If you are connecting to a database on the same computer, use the Local Database. On the Connection Details tab, in the Add Connection window, enter the following information:ĭata source name: For this example, use the alias of the remote database instance, orcl. If Data source does not say Oracle Database (Oracle ODP.NET), select Change.ĭescription of the illustration addconnection2a.gifĬhoose Oracle Database and then select Oracle Data Provider for. When the Add Connection window appears, determine if the Data source says Oracle Database (Oracle ODP.NET).ĭescription of the illustration addconnection1a.gif In Server Explorer, right-click Data Connections.ĭescription of the illustration addconnection1.gif

#Oracle sql studio how to#

This section shows you how to use the Server Explorer to connect to the Oracle Database for the purpose of automatically creating or modifying database schema objects.įrom the View menu, select Server Explorer.