SQL compiler

[TheStandard]

Is there a free alternative to Oracle 9i? It's too expensive.

 

[sem]

It depends on what kind of alternative you need. Do you need just a relational database& If so ther's a plenty of free alternatives - MySQL, PostgreSQL etc. Apparently Oracle may be an overkill for some less complex tasks, but again, it depends on.

Regards, Dima

http://seminihin.narod.ru

 

[TheStandard]

Aren't the alternatives you mentioned for open source operating systems only? I'm using Windows XP.

I just need something to practice PL/SQL code.

 

[dbtoo2001]

You mean something like oracle 9i personal edition?

http://otn.oracle.com/software/products/oracle9i/htdocs/winsoft.html

 

[dsanchez2]

I think that PL/SQL is available only in Oracle. The other databases have similar procedural languages but are different from PL/SQL.

On a positive note: For development and studing purposes you can download and use Oracle for free. Double check the license agreement, but the last time I checked this was the case.

 

[sem]

I don't know products developed for OSS operating systems only and nothing in their licenses prevents you from using them on commercial OS. AFAIK both databases are supported on Windows.

Regards, Dima

http://seminihin.narod.ru

 

[TheStandard]

Thank you all for your input. I didn't even know such a version of Oracle existed.

sem is right about that overkill part, though. I just wanted to use SQL Plus but got so many other things in addition.

I wasn't expecting to enter to enter a user name, password, and host name for the personal edition.

I'm sure a lot of you are very experienced with Oracle9i, so how do I set up a host name, etc.?