Version 9.0.1.1.1
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Version 9.0.1.1.1

  1. #1
    Join Date
    Sep 2006
    Posts
    7

    Version 9.0.1.1.1

    Hello friends..my 1st post..and a newbie with oracle adn SQL.....
    I wa going thru SQL tutorials....

    WHile trying some of the queries....i came to know that it has three tables....EMP, SALGRADE, DEPT, BONUS...
    EMP has 14 rows with smith allen and ward etc....
    I am reading tut with example..emp table but with entries as
    king, kochhar, etc....i know these tables r in next version of SQL..correct me if i am wrong...
    Can anybody guide me where can i get the tables/ script to this tables.....so i can easily practise and verify my answers......

    waiting anxiously

  2. #2
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Quote Originally Posted by database123
    Can anybody guide me where can i get the tables/ script to this tables.....so i can easily practise and verify my answers......

    waiting anxiously
    Are you are asking for the tables in scott schema?then

    ORACLE_HOME>rdbms>admin>scott.sql
    "What is past is PROLOGUE"

  3. #3
    Join Date
    Sep 2006
    Posts
    7
    NO ...i want the script or table which will have the example as i have in my tuts...like the version i have, has just 4 dept ...but the tuts i am referring has 8 dept...i mean the latest version table

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Ypou might do well to get a more recent version of Oracle -- if the sample data is different then you're working on a different version to that which the tutorial writers were expecting anyway.

    If it's SQL practice you want the grab a copy of Oracle Express Edition -- easy install and administration.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  5. #5
    Join Date
    Sep 2006
    Posts
    7
    Did u mean enterprise edition......???

    Thats the point..i do not wanna get the other edition..but get the script which willl just be enough to help me practise with tut i have

  6. #6
    Join Date
    Jun 2006
    Location
    Wales, UK
    Posts
    62
    The problem you're facing is that Oracle updated the data but not the tutorials.

    As slimdave suggested, download ORACLE EXPRESS EDITION - this is not the same as Enterprise Edition. You can download it from here:

    http://www.oracle.com/technology/sof.../xe/index.html

    Good luck with your learning!

  7. #7
    Join Date
    Sep 2006
    Posts
    7
    I am having oracle 9i..will 10g work with it..or its complete new installation o 10g required??? i am also reffering to 9i tuts only..so help me out...

  8. #8
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    You can install both. You might like to get the Oracle VMWare appliance.

    http://www.vmware.com/vmtn/appliance...ry/oracle.html
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

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



Click Here to Expand Forum to Full Width