Posted on 2001-06-08
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.

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!


Accepted Solution

dbalaski earned 200 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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Suggested Courses

628 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