Cover
title | : | Oracle9i Development By Example |
author | : | Hotka, Dan. |
publisher | : | Pearson Education, Inc. |
isbn10 | asin | : | 0789726718 |
print isbn13 | : | 9780789726711 |
ebook isbn13 | : | 9780768654899 |
language | : | English |
subject | Oracle (Computer file) , Relational databases, Computer software--Development. |
publication date | : | 2002 |
lcc | : | QA76.9.D3H659 2002eb |
ddc | : | 005.75/85 |
subject | : | Oracle (Computer file) , Relational databases, Computer software--Development. |
Page i
Oracle9i Development
BY EXAMPLE
Dan Hotka
Page ii
Oracle9i Development by Example
Copyright 2002 by Que Publishing
All rights reserved. No part of this book shall be reproduced, stored in a retrieval system, or transmitted by any means, electronic, mechanical, photocopying, recording, or otherwise, without written permission from the publisher. No patent liability is assumed with respect to the use of the information contained herein. Although every precaution has been taken in the preparation of this book, the publisher and author assume no responsibility for errors or omissions. Nor is any liability assumed for damages resulting from the use of the information contained herein.
International Standard Book Number: 0-7897-2671-8
Library of Congress Catalog Card Number: 20-01098174
Printed in the United States of America
First Printing: December 2001
04 03 02 01 4 3 2 1
Trademarks
All terms mentioned in this book that are known to be trademarks or service marks have been appropriately capitalized. Que cannot attest to the accuracy of this information. Use of a term in this book should not be regarded as affecting the validity of any trademark or service mark.
Warning and Disclaimer
Every effort has been made to make this book as complete and as accurate as possible, but no warranty or fitness is implied. The information provided is on an ''as is" basis. The author and the publisher shall have neither liability nor responsibility to any person or entity with respect to any loss or damages arising from the information contained in this book.
Associate Publisher
Dean Miller
Executive Editor
Candy Hall
Acquisitions Editor
Michelle Newcomb
Development Editor
Howard Jones
Managing Editor
Thomas Hayes
Project Editor
Tricia Liebig
Copy Editor
Sossity Smith
Indexer
D&G Limited, LLC
Proofreader
D&G Limited, LLC
Technical Editor
Patrick McGrath
Team Coordinator
Cindy Teeters
Media Developer
Michael Hunter
Interior Designer
Karen Ruggles
Cover Designer
Duane Rader
Page Layout
D&G Limited, LLC
Page iii
Contents at a Glance
Introduction | |
Part I Learning the Oracle9i Basics | |
1 Introducing Oracle9i | |
2 Fundamentals of the SQL Language | |
3 Fundamentals of PL/SQL | |
Part II Building Oracle9i Database | |
4 Building an Oracle9i Database | |
5 Building Oracle Forms | |
6 Building Oracle Reports | |
7 Using Advanced SQL Techniques and SQL*Plus Reporting Features | |
8 Building Web Sites with Oracle9i | |
9 Using PL/SQL to Build Web Sites | |
10 Using Java to Build Web Sites | |
11 Using XML to Build Web Sites | |
12 Using Portal v3.0 (WebDB) Web Development Software | |
Part III Oracle9i Tuning Issues | |
13 Oracle9i Indexing Options | |
14 Oracle9i Application SQL Tuning | |
15 Oracle9i Partitioning Features | |
Part IV Working with Oracle9i Tools and Utilities | |
16 Using TOAD in the Development Arena | |
17 Using SQL*Loader, External Tables, Export, Import | |
18 Using Log Miner | |
Part V Putting It All Together | |
19 Putting It All Together; a Sales Tracking Application | |
Part VI Appendixes | |
A Answers to Quizzes | |
B Complete Sales Tracking Installation Scripts | |
C Web Sites and Product Codes | |
Glossary | |
Index | |
Page iv
Table of Contents
Introduction | |
Part I Learning the Oracle9i Basics | |
1 Introduction to Oracle9i | |
OracleA Relational Database | |
What Is a Database? | |
Introduction to SQL | |
Oracle9i Features | |
Oracle9i Object-Oriented Programming | |
Oracle9i New Features | |
Introduction to Oracle Tools | |
Oracle Developer 6.i (Forms, Reports, and Graphics) | |
SQL*Plus | |
SQL*Loader | |
External Tables | |
Net8 | |
Log Miner | |
Export/Import | |
Reviewing It | |
Checking It | |
What's Next? | |
2 Fundamentals of the SQL Language | |
SQL Language Basics | |
Log In to the Database | |
The SQL Editor | |
Introduction to SQL | |
Tables EMP/DEPT Setup | |
Learning the Basics | |
Next page