Geek Answers Handbook

How to get into Oracle development?

I am a .net / C # developer, but I need to set up the Oracle development platform. I have no idea about Oracle, and was hoping for some advice. Here are some things that interest me:

  • What is licensing? Is it possible to get copies of Oracle products for development in the same way that we get SQL Server from MSDN?
  • What operating system should be used on the primary server machine? Are specifications important?
  • What is the current state of interaction with .Net-Oracle? Are there any tools worth checking out?

Thanks for the answers and sorry for the question at the beginner level.

+7
oracle
source share
4 answers

A good place to start might be with Express Edition: http://www.oracle.com/technetwork/database/database-technologies/express-edition/overview/index.html

It is free and allows you to play and feel things. As already mentioned, you can also get test versions of some enterprise products.

It runs on Widnows (so you won’t need to install new OS) on most desktop computers. I believe that I need about 2 gigabytes of RAM to run Oracle and other tools, but YMMV.

Installation and management of the server is carried out through the web application into which it is included, although Oracle also has a free SQL Developer tool ( http://www.oracle.com/technology/products/database/sql_developer/index.html ) you can use (which I prefer).

+5
source share

Oracle Developer Tools for Visual Studio can be useful (I like being able to manage some databases directly in visual studio, especially when you have only a few simple tasks). And more generally, the .NET Developper Center , where you can find many products, help, and articles on .Net <=> Oracle interactions.

+2
source share

  • yes - it’s actually a little easier: just register for an OTN account and you can download corporate versions of the database for development / testing. As far as I remember, this is done on the basis of trust - that is, there are no naked screens, checks, etc.

  • Database software is available for Linux, windows, and almost certainly other platforms. I found that installation would be much less painful for windows.

  • There is an ODP driver to facilitate the connection between .Net and Oracle

Hope this helps!

+1
source share

Personally, I would forget about Oracle Express and instead download the full version of Oracle Enterprise Edition. On Windows, this is fairly easy to install, and you can use it for development, prototyping, or self-education purposes without having to buy a license.

As others have said, you will also want to download the ODAC / ODP.NET and SQL Developer drivers.

To begin with, you can try out some of the Oracle tutorials by example . They will guide you through the basics (installation, PL / SQL development using SQL Developer).

I would also recommend reading the first few chapters of Tom Keith’s book, an expert at Oracle Database Architecture: programming methods and solutions.

0
source share

More articles:


All Articles