Oracle / SQL

[glass]

We have to practice SQL but not using Microsoft SQL server which I already have installed.

We have to practice using Oracle.

Can somebody please tell me which / what is the name of the software ( exact ) and if it can be downloaded legally from the net. I am using Win XP.


Awaiting your kind assistance .

[Sykora]

You can download it from the official Oracle site. For school work, Oracle 9i Personal should do. It's a large download though, about 3 CDs worth.

Remark : Oracle is *_incredibly_* difficult to install. It took me 3 or 4 attempts before I could get it working properly. Sometimes it just hung on me, and then I had those password problems.

[arunks]

not really it is difficult to install but its time consuming..it will also work i f u just press "next" button on every screen..i do this only everytimes..jsut when password management is shown then i cahnges password of scott user..e

[gaurav_indian]

Oracle 10i is the latest that I have heard.Also the queries are quite similar like MS SQL Server.But I think SQL is good and fast.But Oracle slows down the system.

[arunks]

hey its 10g not 10i...gaurav

[glass]

Thanks guys I did see the oracles website and I found some links , will review them tomorrow.

[mediator]

http://www.oracle.com/technology/software/products/ias/index.html
470 MB download for Windows! But yeah oracle is damn heavy on system. u can use mysql. Not much of difference. BUt u shud implement functions and procedure on oracle. I cudnt get them to work on mysql.

[gaurav_indian]

hey its 10g not 10i...gaurav
I think if u r saying 10g then it's also old.Oracle 11i is the latest i googled that.

[it_waaznt_me]

For personal and academic use, Oracle provides a free version Oracle Xpress Edition (http://www.oracle.com/technology/products/database/xe/index.html). Its not a very big download and it will provide you with all the tools you need to learn Oracle Sql . ..

[gaurav_indian]

For personal and academic use, Oracle provides a free version Oracle Xpress Edition (http://www.oracle.com/technology/products/database/xe/index.html). Its not a very big download and it will provide you with all the tools you need to learn Oracle Sql . ..
Which one to download Oracle 10g Express Edition or Oracle 10g Client Edition?

[it_waaznt_me]

You should download Express Edition .. .

[glass]

Thanks for all the help, I am downloading the express version of 10g right now but even the complete one is available for free download.

CYa Guys

[Sykora]

I think you made the right choice. You'll probably be spared the horrors of full-blown installation.