Oracle Developer Tools for Visual Studio .NET
page 2 of 7
by Steven Swafford
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 33073/ 85

Oracle Explorer Overview

To work with an Oracle database within the Visual Studio .NET IDE is as simple as selecting the node that you wish to work with. As you will notice in figure 1, you have access to tables, views, procedures, functions, packages, synonyms, sequences, XML database, and finally Java classes.

Figure 1: Example Oracle Explorer Window

One thing that you should be aware of after installing this product is that the explorer tab is not visible by default; you must add it manually. To accomplish this step, click Tools and Connect To Oracle Database. Once you do this, a window will present itself where you must select your data source, authentication method, and role. In this example, I am connecting to a data source named PORTAL and using the username HR that has the necessary rights within the HR schema. Be sure to test your connection to ensure you have connectivity to your database.

Note that you can also access Oracle Explorer by Clicking View and selecting Oracle Explorer.

Figure 2: Add Connection Properties

With all of these entities available directly from within the IDE, it is simply a matter of expanding the particular node that you wish to work with. While I will not cover each of these in detail, I will touch on those items that you as a developer may find the most useful during your development efforts.

View Entire Article

User Comments

No comments posted yet.

Product Spotlight
Product Spotlight 

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2021  |  Page Processed at 2021-04-16 9:52:53 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search