Oracle / SQL

glass · 07-08-2006, 06:57 PM

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 · 07-08-2006, 07:06 PM

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 · 07-08-2006, 09:18 PM

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 · 07-08-2006, 09:20 PM

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 · 08-08-2006, 10:39 PM

hey its 10g not 10i...gaurav

glass · 08-08-2006, 11:30 PM

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

mediator · 09-08-2006, 05:14 PM

http://www.oracle.com/technology/sof...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 · 09-08-2006, 06:21 PM

Quote:

Originally Posted by desmataks

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 · 09-08-2006, 10:19 PM

For personal and academic use, Oracle provides a free version Oracle Xpress Edition. Its not a very big download and it will provide you with all the tools you need to learn Oracle Sql . ..

gaurav_indian · 09-08-2006, 10:23 PM

Quote:

Originally Posted by it_waaznt_me

For personal and academic use, Oracle provides a free version Oracle Xpress Edition. 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?