Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17



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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Expert Comment

ID: 6168414
You can download personal oracle 8i (and personal oracle 8) for Windows 98 machine from (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.

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.


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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This post first appeared at Oracleinaction  ( 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…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

705 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