Join Dotnetcodes DotnetCodes.com is online Discussion Forum for Software professionals . It lets you find friends around the world and Create professional network that share similar interests as you. Get help on ur projects by industry specialists. Also get answers to all ur technical/placement related querries.Get an edge over others.
Already MemberClick here to login
ASP.net MVC Interview Questions Answers Interview Questions
Get Started Developing for Android Apps with Eclipse Articles
Serial Number in SSRS Articles
.Net framework 4.0 Interview Questions Answers Interview Questions
SQL server reporting services Interview Questions (SSRS) part 1 Articles
Whats New in ASP.NET 4.0 Part 2 Articles
How to Print a Crystal Report direct to printer Articles
Difference between Encapsulation and Abstraction Interview Questions
Explaining SDLC -System Development Life Cycle Articles
Html5 interview questions and answers Interview Questions
SharePoint 2010 interview Questions Answers Interview Questions
Infosys Interview Questions Interview Questions
Dynamic Menu using HTML List Tag and CSS in ASP.Net Articles
Populate or bind Dropdownlist in Asp.net using Jquery and Json Articles
ASP.NET MVC Overview Interview Questions
Submit Articles | More Articles..

Oracle Developer Tools(ODT) for Visual Studio

Posted By: rakesh On:8/16/2010 1:43:42 AM in:Articles Category:VS 2010 Hits:2824
The Oracle Developer Tools for Visual Studio (ODT) is a tightly integrated Add-in for Microsoft Visual Studio. ODT is free and new version of ODT support for Visual Studio 2010. Visual Studio 2008, and Visual Studio 2005 are also supported.

Oracle Developer Tools (ODT) for Visual Studio


  • Integrated Online Help System: The integrated context sensitive online help, including the Oracle SQL and PL/SQL Users Guides puts the Oracle documentation at your fingertips.
  • Manage Users, Roles and Privileges:  Create Users and Roles using graphical designers. Assign privileges to the roles and assign roles to users. View the Users and Roles in Server Explorer.
  • Oracle Advanced Queuing (AQ) Designers:  Create, modify and administer your Queues and Queue Tables.
  • User-Defined Types (UDTs): Create UDTs in Oracle with multiple new designers. A powerful UDT Custom Class code generation wizard makes using UDTs from .NET code easy and fast.
  • Import Table Wizard: This wizard makes it easy to import tables and their data from Oracle databases, or from external datasources such as Microsoft SQL Server, Microsoft Access and Excel spreadsheets.
  • Data Editing, Stored Procedure Testing, Adhoc SQL Execution: When testing your .NET application you can use the Oracle Data Window to insert and update Oracle data. There's also a testbed for testing stored procedures and an Oracle Query Window for executing any SQL statement you choose.
  • Powerful Application Tuning Tools: Use Oracle Performance Analyzer to tune your .NET application's use of Oracle Database via a single click of a button. The database is then monitored under load and recommendations are made, such as modifications to SQL or adding an index on a table. You can also tune Ad-hoc SQL statements in Query Window with SQL Tuning Advisor.
  • SQL Script Lifecycle with Source Control Integration: Generate SQL scripts for Oracle schema objects that your .NET application uses, manage them in an Oracle Database Project, check them into source control, edit the scripts in the Oracle SQL Editor, and execute them with a built in SQL*Plus execution engine.
  • PL/SQL Editor and Debugger: The fully integrated PL/SQL Editor and Debugger allows you to leverage all of your favorite Visual Studio debugging features from within PL/SQL code. You can even seamlessly step from your .NET code into your PL/SQL stored procedure code and back out again!
  • NET Stored Procedure Deployment: The .NET Deployment Wizard makes it easy to deploy .NET stored procedures and functions into Oracle Database.
  • Integration with Visual Studio: Use Server Explorer to browse your Oracle schema and launch one of the many integrated Oracle designers and wizards to create and alter schema objects. Use Microsoft Query Designer to visually design queries.
  • Automatic .NET Code Generation: Use the Visual Studio Datasources Window, the Dataset Designer, and the TableAdapter Configuration Wizard to drag and drop and automatically generate .NET code.
  • Easy ASP.NET Web Development: If you're an ASP.NET web developer, ODT makes it easy to generate ASP.NET web applications with minimal coding required.


comments powered by Disqus
User Profile
Rakesh Sinha
Sr. Technical Lead
New Delhi , India
Email :You must Log In to access the contact details.
Latest Post from :rakesh
Response.Redirect vs Server.Transfer
View: 396 | Submitted on: 12/27/2015 2:26:38 PM
The test form is only available for requests from the local machine.
View: 438 | Submitted on: 11/3/2015 9:54:36 PM
Difference between web service WCF and Web API
View: 5501 | Submitted on: 10/28/2015 9:23:51 PM
Which party you want to vote in Delhi assembly elections 2015?
View: 1433 | Submitted on: 12/18/2014 4:19:24 AM
How to Calculate sum of a column in a dataset
View: 1101 | Submitted on: 9/17/2014 6:48:19 AM
Submit Articles | All Post of This User..

All rights reserved to dotnetcodes. Logos, company names used here if any are only for reference purposes and they may be respective owner's right or trademarks.
Best viewed at 1024 x 768 resolution with Internet Explorer 5.0 or Mozila Firefox 3.5 or Google Crome and higher