Oracle Developer / Trial Editions Available?

[Ovatvvon]

Hi,

I'm a SQL Server DBA. I wanted to take a look into Oracle for comparison reasons - for myself. With SQL Server, you can buy a developer edition for $50, which has all the features of the Enterprise Edition (highest level), but not the licensing, so only one developer can use it for non-productive use.

I was curious if Oracle has anything like that for its DBMS?

Also, does it have a 64-bit version for Windows Server 2003 64-bit version, or does it strictly operate in a 32-bit environment?

Thanks a bunch for your help!


-Ovatvvon :-Q

 

[Thargy]

you may download the oracle of your choice, from express (the lite version) all the way up to Enterprise with partitioning, olap, data mining and all the twiddly bits you can think of.

These are all free for personal use.
Oracle doesn't come with an IDE, because it's multi-platform, i.e. it can run on solaris, aix, hpux, windows etc.

However, for the windows environment, there is a free-to-download tool from oracle called SQL Developer, which should give you a user-friendly starting point. I think the latest version is 3.2 ish, but check the web site to be sure.

Oracle uses sqlplus as its scripting tool. I believe this is similar to sql analyzer in sql server land.

Oracle runs on both 32 and 64 bit windows, just make sure you download the one that suits your hardware.

Grinding away at things Oracular