Go Premium for a chance to win a PS4. Enter to Win



Posted on 2001-06-08
Medium Priority
Last Modified: 2010-08-05
Pardon my english.
I don't have any experience in Oracle 8i. I know some MS Access and MS Access SQL. I never use Oracle 8i before. What should I learn first before learning Oracle 8i? I know there is to get oracle server. I can download a free copy of Oracle8i from Oracle website. What is difference between Oracle8 and Oracle8i? Will I learn Oracle forms, reports, etc in Oracle8i? I know Visual Basic, Active Server Pages and bit JAVA. Please advise.

Question by:vb6vb6

Expert Comment

ID: 6168414
You can download personal oracle 8i (and personal oracle 8) for Windows 98 machine from technet.oracle.com (registration is free)

Oracle 8 is without JAVA VIRTUAL MACHINE.

Oracle 8i is with Java Virtual machine as well as next version of 8., various other things useful for Internet are also included in 8i.

i stands for Internet.

Author Comment

ID: 6168567
Don't post this as answer. I want the other experts to have an opportunity to give me a few suggestions or comments. I am looking for the good answer to my question. More comments? More suggestions? More ideas?

Expert Comment

ID: 6168648

What should I learn first before learning Oracle 8i?

Learn the basics of RDBMS (Relational DataBase Management Systems). Then read through the Oracle Server Concepts. Understanding the basics makes things much easer as you expand your knowledge.
Any of us could list ten or more books to read, but they may not be right for you. Go down to the local book store and start reading.

What is difference between Oracle8 and Oracle8i?

If you don't understand the Oracle database, pointing out the differences between these two would be meainingless. I have been working with Oracle for more than 8 years and I'm still learning.

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  


Accepted Solution

dbalaski earned 800 total points
ID: 6168700

The main difference between 8 and 8i is mostly enhancements --  few exceptions, such as the JVM.
Some typical enhancements include:
 Optimizer (specically CBO, &  query rewrite)
 Materialized views,
 Indexed-Organized Tables,
 Transportable Tablespaces,
 Indexes (Reverse Order,  additions to bitmaps, function based indexes)

There are a ton more --   You can read about them in the oracle manual:  Getting to Know Oracle8i Release 2 (8.1.6)
Part Number A76962-01
(you can down the manual sets from TECHNET.ORACLE.COM)

As far as your question:
Will I learn Oracle forms, reports, etc in Oracle8i?
No -- not unless you download those products and read the manuals for them --  they are seperate products from the database.

What should I learn first?
1)  Learn  standard ANSI SQL   and some relational database concepts.    A good book for this (the best I've ever seen):
An Introduction to Sql: Mastering the Relational Database Language
by Rick F. Van Der Lans
Addison-Wesley Pub Co; ISBN: 0201596180
published 1999

2)  Read the following Oracle manuals:
Oracle8i Concepts Release 2 (8.1.6)
Part Number A76965-01
This will cover all the oracle specifics.

Oracle8i Designing and Tuning for Performance Release 2 (8.1.6)
Part Number A76992-01
This will bring you more into the finer points of the Oracle database.

From this point,  you will have a good start..

Hope this helps & answers your question


Expert Comment

ID: 6175786
when you use Access, it doesn't follow Client/Server standard. So you should choose SQL Server or Oracle. SQL is suitable for small and medium projects, especially for web-based applications, but when using for large projects like in bank, goverment projects you should change to Oracle.
LVL 48

Expert Comment

ID: 6175990
You have to buy books. The first book you need is "Oracle 8i - The complete Reference". You have to learn very good SQL and also to know PL/SQL. The best book I know is Steve's Feuersten "Oracle PL/SQL Programming". After that you have to decide what role would you play in the Oracle world:
- Data Base Administrator (PL/SQL, Principles of Oracle)
- Application Designer and Developer (Design of tables, Oracle orms and Reports)
- Internet Applicaton Development (Java, JBuilder, JSP, ...)

Author Comment

ID: 6179172
Is personal Oracle8i free, full version? Is it a trial version? I am going to download it tonight. Where can I find the personal Oracle 8? Is it free downloadable? I know some ASNI SQL and some relational database concepts. I think I should have no problem with using Oracle8i. Will I design the forms, reports, etc in Oracle8? What about Oracle8i? Please advise.

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

963 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question