Skip to content

Oracle8i for Dummies

Spend $50 to get a free DVD!

ISBN-10: 0764507982

ISBN-13: 9780764507984

Edition: 2nd 2001 (Revised)

Authors: Carol McCullough-Dieter, Ned Dana

List price: $24.99
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!


In Oracle8i For Dummies, Second Edition, author Carol McCullough takes the complexity out of the features available in Oracle8i Release 2 and Enterprise Manager version 2.1.4 and makes them easy to understand. She'll uncover all you need to know about features like built-in support for XML and Enterprise Java Beans, new security options for Internet applications, and new performance and tuning tools included with Enterprise Manager. With her easy-to-follow examples, you'll quickly become familiar with the database and tools and be ready to put them to work.
Customers also bought

Book details

List price: $24.99
Edition: 2nd
Copyright year: 2001
Publisher: John Wiley & Sons, Incorporated
Publication date: 12/15/2000
Binding: Paperback
Pages: 408
Size: 7.25" wide x 9.25" long x 1.25" tall
Weight: 1.430
Language: English

Why This Book Makes Sense
Some Basic Assumptions
Quickie Overview of This Book
Of Mice and Sven (Mouse Moves and Special Text)
Icons Used in This Book
Road Map
A Quick Tour of Oracle8i
Discovering Oracle8i: The Program That Runs It All
The Oracle8i core package
The Oracle8i newest stars: XML and Enterprise Java Beans
The new look of Enterprise Manager
DBA Studio packs four all-star components
Starting Up Oracle8i
Starting the database with the Instance Manager
Starting Oracle8i using SVRMGRL
Looking Around with DBA Studio
The Object/Object Contents window
The other Schema Manager elements
Other Elements: The Main Menu and Button elements
Getting Acquainted with SQL: The Messenger Priestess of Oracle8i
Starting and stopping SQL*Plus on a desktop
Using SQL*Plus in line command mode
Initializing the Enterprise Manager Console
Creating a repository for Enterprise Manager Version 2.1
Starting the Agent
Starting the Enterprise Management Service
Setting up a Web-based Console and DBA Studio
Taking a quick tour of Enterprise Manager Console
Getting Help: Let Your Mouse Do the Walking
Shutting Down Oracle8i
Shutting down Oracle8i on a desktop
Starting the database with the Instance Manager
Shutting down Oracle8i on a mainframe or a network
Data Whaaat? A Database Primer
Dataspeak Definitions for the Techno-Impaired
Relational Database Concepts
Users and roles
Columns and rows
Object-Relational Database Concepts
An object defined
The scoop on object types
The connection of relational tables with objects
Object reference
Methods to their madness
Nested tables
The Kinds of Database Things That You Can Do with Oracle8i
Keeping track of a fishbowl (the easy example)
Running a pet shop (the medium example)
Tracking endangered species globally (the hard example)
SQL Nuts and Bolts
Starting Up SQL*Plus
Asking a Question in SQL
The basic SQL query
Some sample queries
Some tips to help you write good queries
Using an Editor While Running SQL*Plus
Pulling Out Data without Breaking Anything
Combining Tables: The Meat and Potatoes of SQL
Basic join query structure
Examples of join queries
Using the Built-In Functions of Oracle8i
Reformatting a date with TO_CHAR
Concatenating columns with CONCATENATE (11)
Grouping and Summarizing Data
Making Power Changes in the Data
Modifying data with the UPDATE command
Inserting new rows with grace and style
Deleting rows with distinction
Fixing Mistakes, or Where's the Brake?!
The COMMIT and ROLLBACK commands
Commands that can't be undone, even with ROLLBACK
Object SQL: The New Stuff
Starting Up SQL*Plus
Querying Object Tables in SQL
The basic object-oriented SQL query
Queries using a nested table
Queries using an array
Making Changes to Object Table Data
Updating an object
Updating one row in a nested table
Inserting rows into an object table
Inserting rows into an array
Inserting rows into a nested table
Deleting rows from an object table
Deleting a row from a nested table
Using the Enterprise Manager DBA Tools
The New Look of Enterprise Manager
Exploring Four Cornerstone Tools
Storage Manager: The external viewpoint
Security Manager: The keeper of the gate
Schema Manager: The builder of tables
Instance Manager: The activity monitor
Getting Started
The Relational Model and You
Redundant Relational Database Redundancy
Keys Rule
Considering types of keys
Importing foreign keys
The Key, the Whole Key, and Nothing but the Key
One Too Many: The Bread and Butter of Relational Databases
Objects and the Oracle8i Database
Defining an object
Connecting relational tables with objects
Diagramming Your World
Getting Something Down on Paper
Using Tree Diagrams: Easy When You Know the Lingo
Hooking Up with Objects
Understanding the Basic UML Type Model Diagram
Getting Familiar with Oracle8i Data-Dictionary Views
Viewing the Oracle8i Data-Dictionary Views
Using Data-Dictionary Views
Looking at Data-Dictionary Views with SQL*Plus
Oracle's User
Playing a Role
What kinds of users are there?
What kind of user are you?
Creating a New User from Scratch
Changing Your Password
Changing your password in SQL*Plus
Changing any user's password in Security Manager
Changing User Identity
Putting Oracle8i to Work
Defining Tables, Tablespaces, and Columns
Tablespace: The Final Frontier
A Word or Two about Columns
Defining columns in Oracle8i
Allowing nulls or not
A Table of Your Own with SQL
Schema Manager's Spreadsheet for Tables
Creating Object Types, Objects, and References
Types Need No Space
Defining an object type
Making a table type
Creating an array type
Objects Still Sit inside Tablespaces
Making an object table
Making a hybrid table
Security Options: Roles and Grants
Security Blanket Included
Roles Meet the Real World
Roles and Privileges with Security Manager
Creating a role and assigning object privileges
Assigning users to a role
Assigning privileges to roles with SQL*Plus
Roles and Privileges with SQL
Views and Synonyms: Do You See What I See?
Views: Like a Table--Almost
Views that narrow
Views that tie everything together
Views with Schema Manager
Object views with Schema Manager
Synonyms: Nicknames for Tables and Views
Good uses for synonyms
A grant and a synonym combined
Materialized views--pros and cons
Oracle Portal: The Best New Tool for the Internet
Exploring Oracle Portal
Assigning WebDB Developers
Creating a Web Report
Going for a Form
Java and the Internet Database
Discovering Java Virtual Machine (JVM)
Using the Oracle8i JVM--some benefits
Introducing SQLJ
Creating a Stored Database Procedure with Java and SQLJ
Writing Java code with embedded SQLJ
Loading the Java into the database
Creating a SQL wrapper for the Java code
Using the SQL wrapper in a SQL query
Running a Java Applet that Queries the Database
XML and Enterprise Java Beans
What is XML?
A Sample XML XSQL Servlet
Anyone for EJB?
The Five Ws of Safeguarding Your Data
Why Back Up--Onward and Upward!
What to Back Up
When to Back Up (Before You Go Off the Cliff)
How to Back Up (Choosing Your Backup Weapon)
Data Manager
EXP and IMP commands
Where to Hide Your Backup Files
Tuning Up and Turbocharging
What's Slowing Down Your Query?
Helping the Optimizer Do Its Job
Moods and modes of the Optimizer
One command to analyze your entire schema
Personal attention: Analyzing one table at a time
A hint ... you're getting warmer
Getting Ahead While Testing and Tuning
Using EXPLAIN PLAN to see your query's plan
Speeding Up Queries with Keys and Indexes
Why Create an Index?
Adding and Removing a Primary Key
Adding a primary key
Removing a primary key
Creating and Dropping Foreign Keys
Adding a foreign key
Removing a foreign key
Creating Your Own Indexes
Adding an index
Removing an index
Using Indexes with Object Tables and Nested Tables
Creating an index on an object table
Creating an index on a nested table
Removing an index on an object table or a nested table
The New Oracle Tuning Pack
Watch the Index Tuning Wizard work its magic
Let SQL Analyze help tune queries
Correcting Flaws
Categories of Column Changes
Baby Bear: Easy as Porridge
Mama Bear: A Few Medium Steps
If the column must be null ...
Column must not have nulls
Papa Bear: A Lotta Steps
Modification of Object Tables in Schema Manager
The Oracle Change Management Pack--Something New to Try!
The Part of Tens
Ten Tips for Good Design
Name Tables and Columns Creatively and Clearly
Look Before You Leap (Design Before You Build)
Go Ahead, Leap! (Build a Prototype)
Share--Don't Reinvent the Wheel
Remember that Primary Keys Are Your Friends
Small keys take up less room
Nonintelligent keys are easy to maintain
Use Caution When Modifying Table Definitions
Handle Derived Data Efficiently
Approach Internet Security in Practical Ways
Low security--application proxy
Medium security--application context
High security--SSL
Be Smart about Test Data
Talk to Non-Techie-Type Humans
Ten Handy Oracle8i Internet Features
Net8 with SSL
PL/SQL on the Web
Internet File System (iFS)
Java Stored Procedures
Web Assistant
Visual Information Retrieval (VIR)
Portal to Go
Book Registration Information