Results 1 to 14 of 14

Thread: Learning SQl - oracle download?

  1. #1
    Panzer Division Marduk PanzerKnight's Avatar
    Join Date
    Jul 2003
    Location
    Surrey
    Posts
    555
    Thanks
    6
    Thanked
    0 times in 0 posts

    Question Learning SQl - oracle download?

    hi there,

    looking to learn databases and sql over summer and was wondering if anyone knew where i could download Personal Oracle 7 from? Failing that, i see there is Oracle 10g downloads from their site, but not sure which one to get.
    1. Oracle Database 10g Release 1 (10.1.0.2)
    2. Oracle Database 10g Companion CD Release 1 (10.1.0.2) for Microsoft Windows (32-bit)
    3. Oracle Database 10g Client Release 1 (10.1.0.2) for Microsoft Windows (32-bit)
    4. Oracle Cluster Ready Services Release 1 (10.1.0.2) for Microsoft Windows (32-bit)
    5. Instant Client


    Just want to try out these sql commands i have in a tutorial and create a database. Tried mysql...but think i messed it up as nothing happens lol.

    Also trying to learn java...anyone know a good site for complete programming n00bs?

    Thanks for any help.

    Panzer

  2. #2
    Member
    Join Date
    Aug 2003
    Location
    Wimbledon
    Posts
    141
    Thanks
    0
    Thanked
    0 times in 0 posts
    Go for number 1, its everything you need.

  3. #3
    Commander Keen
    Join Date
    Nov 2003
    Location
    217.27.240.214
    Posts
    624
    Thanks
    0
    Thanked
    0 times in 0 posts
    Presuming you get oracle set up correctly.. I think under windows you have to register it as an ODBC data source before you can access it. But I have never used oracle db so this is speculation.

    I would always recommend mysql, so I would rather you persevered with this But i found java code that should be able to access an oracle db here

    mysql requires a download for the drivers.. I don't know but assume oracle does too. <- if it does this needs to be added to your classpath.

    The code needs a fiddle to make it work with your db.

    off the cuff I think these changes are..
    1) change the String url to "JDBC:ODBC:<the name of your database>" ;
    2) Line below the second 'try' you need to set <username> and <password> to whatever you have configured you oracle db to use.
    3) then edit "stmt.executeQuery" line to have a useful SQL query for your database.

    Bit of advice. Baby steps are best.
    'Create' a simple table in oracle called 'test'. With one field called 'tester'.
    'Insert' a record to test. <- these two have to be done from oracle before the
    java program is run.

    Then for 3) use Sql = "SELECT * from Test" ;

    Then that while loop at the bottom looks good for printing out anything in the table. Should get the one record from the Test table.

    Best of luck. Anymore help then you know where I am. Stalking this message board.
    Last edited by killgORE; 02-07-2004 at 01:21 PM.

  4. #4
    Commander Keen
    Join Date
    Nov 2003
    Location
    217.27.240.214
    Posts
    624
    Thanks
    0
    Thanked
    0 times in 0 posts
    erm.. have you got linkage to the oracle download ? I really don't want to register soooo many details to get a copy of it - as on the official website.

    They want street address etc.. Only If I am buying stuff do I give this out ! And I don't like filling in crap to peoples databases.

  5. #5
    Panzer Division Marduk PanzerKnight's Avatar
    Join Date
    Jul 2003
    Location
    Surrey
    Posts
    555
    Thanks
    6
    Thanked
    0 times in 0 posts
    cheers for the reply, gettng optin 1, bout 700mb. the url is http://otn.oracle.com/software/produ...s/winsoft.html

    might give mysql another go.. not quite sure what i was doing do. Whenever i ran it a service just started..werent to sure how to access it.

    cheers for the reply, will poke about oracle and c how it pans out

  6. #6
    Panzer Division Marduk PanzerKnight's Avatar
    Join Date
    Jul 2003
    Location
    Surrey
    Posts
    555
    Thanks
    6
    Thanked
    0 times in 0 posts

  7. #7
    Commander Keen
    Join Date
    Nov 2003
    Location
    217.27.240.214
    Posts
    624
    Thanks
    0
    Thanked
    0 times in 0 posts
    700mb !! Bloody hell. What the hell is in that database ? A sample database of BIG images ?

    *sniggers*

    Yeah.. I won't be getting oracle then, it would hog my bandwidth for too long today AND I feel like killing people online.

    MySql is free.. Compact and they don't make you sign up for it.

    Have you got oracle setup right ? and Does the code werk ??

    l8ter

  8. #8
    Member
    Join Date
    Sep 2003
    Posts
    95
    Thanks
    0
    Thanked
    1 time in 1 post
    The difference between Oracle and MySQL is enormous.

    Oracle 10g is huge and way beyond what you will ever need. Try to find a copy of 8i (8.1.7) as this is just a database and not a application server and web server as well!

    It should still be available on OTN.

    http://otn.oracle.com/software/produ...e8i/index.html

    HT

    shout if you need help with installing it, it's not like a normal windows install!

  9. #9
    Panzer Division Marduk PanzerKnight's Avatar
    Join Date
    Jul 2003
    Location
    Surrey
    Posts
    555
    Thanks
    6
    Thanked
    0 times in 0 posts
    lol gave up with orcale mate. Gonna tuff it out with mysql. When i first used it never installed any drivers so thats my prob i think

  10. #10
    Senior Member Shad's Avatar
    Join Date
    Jul 2003
    Location
    In front
    Posts
    2,773
    Thanks
    22
    Thanked
    40 times in 24 posts
    Just to throw a spanner in the works...

    What about MSDE (Microsoft SQL Server 2000 Desktop Engine)?

    "...is the free, redistributable version of SQL Server that’s ideal for client applications that require an embedded database, new developers learning how to build data-driven applications, and Web sites serving up to 25 concurrent users."

    There's also a beta of SQL Server 2005 Express Edition which is basically the same thing but using the next SQL Server engine.
    Simon


  11. #11
    Panzer Division Marduk PanzerKnight's Avatar
    Join Date
    Jul 2003
    Location
    Surrey
    Posts
    555
    Thanks
    6
    Thanked
    0 times in 0 posts
    basically, just need to learn database design for next year. Doing a module on it:

    This module provides a broad understanding of the fundamentals of relational databases, along with practical experience in the design and implementation of a relational database. An overview of emerging concepts for object-oriented and distributed databases is also covered

    there a lot of databases involved with the course so just wanna get a sound understand before i start it and a bit of a headstart

  12. #12
    Senior Member Shad's Avatar
    Join Date
    Jul 2003
    Location
    In front
    Posts
    2,773
    Thanks
    22
    Thanked
    40 times in 24 posts
    Good stuff

    www.devguru.com is a very useful SQL reference, as are the Books OnLine that come with MSDE and SQL Server. www.w3schools.org also have a few good SQL tutorials.

    Worth remembering that each different SQL engine has its own extra commands and funnies.
    Simon


  13. #13
    Panzer Division Marduk PanzerKnight's Avatar
    Join Date
    Jul 2003
    Location
    Surrey
    Posts
    555
    Thanks
    6
    Thanked
    0 times in 0 posts
    thanks, will check both of those tonight

    btw, did you mean http://www.w3schools.com/ ?

    cant get to the .org
    Last edited by PanzerKnight; 29-07-2004 at 05:38 PM. Reason: No point posting a new post

  14. #14
    Senior Member Shad's Avatar
    Join Date
    Jul 2003
    Location
    In front
    Posts
    2,773
    Thanks
    22
    Thanked
    40 times in 24 posts
    Quote Originally Posted by PanzerKnight
    thanks, will check both of those tonight

    btw, did you mean http://www.w3schools.com/ ?

    cant get to the .org
    Yes, sorry! Always getting that URL wrong
    Simon


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Download
    By MurphmanL in forum Software
    Replies: 7
    Last Post: 09-06-2004, 10:46 PM
  2. Oracle SQL
    By Raz316 in forum Software
    Replies: 7
    Last Post: 08-06-2004, 02:20 PM
  3. Learning SQL
    By Lead_Head in forum Software
    Replies: 13
    Last Post: 26-05-2004, 06:54 PM
  4. What old classic games are now FREE to download?
    By Jimmy Little in forum Gaming
    Replies: 7
    Last Post: 24-05-2004, 01:40 PM
  5. SQL help
    By Agent in forum Software
    Replies: 23
    Last Post: 11-11-2003, 09:22 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •